Microsoft Excel Flash Fill (Flash Fill Tutorial)
Flash Fill and Autofill are similar to except that Flash Fill will fill the values down based on a certain logic, while in Autofill, you just have to right click the answer then hold and drag. That logic for Flash Fill is derived automatically once Excel sees a pattern in the data. Use the Excel shortcut key for Flash fill: Control + E