With the pivot table "multiple merge computer data area" function, you can combine data from multiple data tables to a data table, of course, there is a premise that the "list header" should be the same. No matter how many rows of data in each table, will be summarized in a table. Quite convenient. Specific steps are as follows:

1. Click "Data" - "Pivot Table and Pivot Chart"

2. Select "Multiple Merge Computer Data Area "Next.

3. Create a single page field. Next.

4. Add the data areas of the data tables to be merged separately. From Table I all the way to Table N. Next.

5. Select "New Worksheet", OK.

6. The summary results appear, you can then copy the required data from the pivot table to other places in order to remove the unwanted content.

Try it and good luck!