How to Create a Pivot Table From Multiple Pivot Tables

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Consolidating PivotTables

MS Excel is one of the most popular tools within the MS office suite. It allows users to analyze and organize large amounts of data in a matter of seconds with ready-made reports such as automatic formatting for graphs and ready-made templates for reporting such as PivotTables. A PivotTable is a data sheet within Excel which allows users to quickly move, view and organize data. Combining PivotTables is as easy as knowing one simple command.

Advertisement

Step 1

Open the PivotTable you would like to work with. Also open a worksheet you would like to consolidate all other pivot table information onto from one PivotTable.

Video of the Day

Step 2

Click on a cell with the new worksheet where you want to start the consolidated data.

Advertisement

Step 3

Click "Consolidate" on the Data menu.

Step 4

Click on "Sum" (or another function) in the Summary function in the Function box. This is the function you want Microsoft Excel to use to consolidate the data.

Advertisement

Step 5

Input the sheet tab of the first range to consolidate in the Reference box and repeat for each PivotTable you want to grab information from. Select "Create links to source data" check box if you want to update the data and need to know which PivotTables are open to access the data.

Advertisement

Advertisement

Step 6

Create a new PivotTable from the consolidated data. On the Data menu, click "PivotTable and PivotChart Report." Use the data from the consolidated worksheet for your data range and click through all other options. Click "Finished" for consolidated PivotTable.

Video of the Day

Advertisement

Advertisement

references