In a Flash, You Will Literally Fill in Vast Amounts of Excel Data with this Tool

In the newer Excel versions (as of Excel version 2013), a new super hero was born: Flash Fill

The Flash Fill tool brings a whole new level of intuitive assistance when you need to separate cell data or combine multiple cells into another cell. Flash Fill is the bigger, badder cousin to the Auto Fill handle we have come to know and love, and works almost like magic by analyzing what you type into a given cell to pick up on the adjacent columns for patterns by suggesting a fill down option accordingly.

How to use Flash Fill:

1. Create a new column adjacent to existing column(s) within a data list (the list is source data where a pattern is detected)
2. In the newly added column, begin at the top cell and type in the data pattern to be followed
   (see example in picture above where initials are typed beside the President names but only type the first entry!) 
3. Press [ENTER]
4. Now in a second cell below the first cell, start typing the same established pattern and watch for a shadow box to dimly appear with Flash Fill "suggested" fill options
5. Press [ENTER] again to invoke the remaining Flash Fill pattern
   OR
   click the AutoFill handle to copy down the suggested pattern (use the Smart Tag option if necessary to select Flash Fill option)
   OR
   click the Flash Fill button on the Home tab under Fill options
   OR 
   click the Flash Fill button on the Data tab