Consolidated pivot tables

Hello Hortensia,

Thank you for your post. Excel has a Pivot Table consolidation wizard which allows you to consolidate different sets of data into one Pivot Table. You can consolidate different Excel tables or different Access / SQL data sets. The tool can be opened by using the following keyboard shortcut in Excel: Alt+D , then P. From here you can choose your data sources to consolidate.

The only thing to note is that the data sources need to contain the same headings and there should not be any empty rows or columns inside the data.

When you open the wizard, select the "Multiple Consolidation Ranges" option, then follow the steps to add the different data sets to the Pivot Table.

I hope this helps

Kind regards
Marius Barnard
Excel Trainer