How do i merge two pivot tables

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
  1. Click anywhere in the PivotTable. …
  2. On the Options tab, in the PivotTable group, click Options.
  3. 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.

How do you sync two pivot tables?

How do I combine pivot tables from different workbooks?

You May Also Like