If you prefer using Microsoft Excel keyboard shortcuts, press Ctrl+E. When you run Flash Fill, Excel looks for patterns in the data, and tries to apply them to the remaining data in the range.

This is the demonstration file to accompany the article, How to create and populate a table in Microsoft Excel’s Power Query by Susan Harkins.