Ways to summarize Excel multiple tables

Ways to summarize Excel multiple tables

To set up the steps:

1, use the formula to refer to the company 1 of the data. Refer directly to the = number, and then copy 800 rows (the number of rows can be based on the maximum number of rows in the table so that the data can be referenced after it is added).

2. Reference the data of other companies separately. Also refer to the table for sufficient blank lines.

3, select "Auxiliary table", insert-pivot table.

4, set the layout of the PivotTable report.

5, adjust the Data perspective table type

Select Pivot Table-Report layout-data table display

Select Pivot Table-Design-Select the appropriate style

Hides the 0 value of the PivotTable report.

The adjusted statistics are shown in the following figure.