Can you merge two pivot tables together?
To combine the data from all the ranges and create a consolidation that does not have page fields, do the following: Add the PivotTable and PivotChart Wizard to the Quick Access Toolbar. … In the list, select PivotTable and PivotChart Wizard, click Add, and then click OK.
How do I merge pivot tables?
Merge or unmerge cells for outer row and column items
- Click anywhere in the PivotTable. …
- On the Options tab, in the PivotTable group, click Options.
- In the PivotTable Options dialog box, click the Layout & Format tab, and then under Layout, select or clear the Merge and center cells with labels check box.
