Flash Fill automatically fills the cells with the existing data pattern. Please follow the steps below to use flash fill combining data:
Step 1: Type the first data, and select the rest data range you want to fill;
Step 2: Type data with the same rule in the second cell;
Step 3: Press "Enter" key to have the data for all cells.
Alternatively, please see the commands from the ribbon.
Step 1: Type data in the first cell;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Fill" in the Editing section, and select "Flash Fill" from the drop-down list.