Direct Answer • Key Takeaway
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. Note: Flash Fill Is Only Available in Excel 2013 and Later.