How to Use Flash Fill to Combine Data

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.