Excel’s Flash Fill (introduced in Excel 2013) is one of the greatest time-saving features when it comes to fixing data.
Flash Fill allows you to “fix” common data format issues like splitting text, merging text, date extraction, text replacement, formatting and much, much more.
Flash Fill provides an alternative to learning many functions or features used to reshape data, such as:
Flash Fill is located on the Data tab in the Data Tools group and can also be invoked by pressing the CTRL-E keyboard shortcut.
Let’s look at just a few examples of how Flash Fill can aid in reshaping your data.