How to Use Flash Fill in Excel 2016
Microsoft Excel 2016 Tutorial | How to Use Flash Fill:-
Start Flash Fill manually: If Flash Fill is turned on but doesn’t start automatically when you type data that matches a pattern, you can try starting it manually by clicking Data - Flash Fill, or by pressing Ctrl+E.
How to Use Flash Fill in Excel
Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.