When it detects a pattern, Flash Fill automatically fills your data. Flash Fill can, for example, be used to split first and last names from a single column or to combine first and last names from two different columns. Please keep in mind that Flash Fill is only possible in Excel 2013 and later.