Excel 2013’s great new Flash Fill feature gives you the ability to take a part of the data entered into one column of a worksheet table and enter just that data in a new table column using only a few keystrokes. Flash Fill also gives you the ability to combine multiple columns into one. Flash Fill uses patterns to try and figure out what you’re trying to accomplish and applies the results.
