Can you merge two pivot tables into one?

Not directly. Combine the source data and build one pivot, or use the Data Model to relate the sources through a shared table.

How do I combine data from two pivot tables in one chart?

Build one pivot from combined or related sources, then insert a PivotChart from it.

Why does my combined pivot repeat the same total on every row?

The row field comes from a table that isn't related to the measure's table. Use the field from the shared dimension table.

How to combine two pivot tables in Excel

By the Analistable team · Updated 2026-10-07 · 2 min read

Excel has no command to merge two pivot tables. Instead, combine the source data (append the two tables in Power Query) and build one pivot, or add both sources to the Data Model and relate them through a shared table such as Products or Dates. If you only need the numbers next to each other, reference both pivots with GETPIVOTDATA.

Part of our guide: How to combine Excel sheets into one

Pick the approach

Ways to combine two pivot tables
Your two pivots come from…	Approach
Two tables with the same columns (2025 and 2026 sales)	Append the sources, one pivot
Different tables sharing a dimension (Sales and Budget by product)	Data Model with a shared dimension table
Anything — you just need a combined report	GETPIVOTDATA formulas

Same columns: append the sources

Load both source tables into Power Query, add a column that says which source each row came from (for example Year), and Append them. Load the result as one pivot table and put Year in Columns. The two old pivots become two columns of one pivot. Steps: Power Query Append Queries.

Different tables: relate them through a shared dimension

Sales (Product, Amount) and Budget (Product, Target) can't be appended, but both describe products. In the Data Model:

Create a Products table with one row per product (=UNIQUE(VSTACK(Sales[Product], Budget[Product])), pasted as values and formatted as a table).
Add Sales, Budget and Products to the Data Model (Insert → PivotTable → Add this data to the Data Model).
In Data → Relationships, relate Sales[Product] → Products[Product] and Budget[Product] → Products[Product].
Build one pivot: Products[Product] in Rows, Sum of Sales[Amount] and Sum of Budget[Target] in Values.

One pivot showing Sales against Budget
Product	Sum of Amount	Sum of Target
Chair	1350	1200
Desk	3200	3500
Lamp	560	500

Use the Products column from the shared table, not from either fact table — otherwise one measure repeats its grand total on every row.

Just the numbers: GETPIVOTDATA

=GETPIVOTDATA("Amount", PivotSales!$A$3, "Product", A2)

Type = and click a value cell in a pivot to have Excel write this formula. Use one formula per pivot next to a list of products to build a combined report that updates when the pivots refresh.

Which approach should you pick?

If you'll keep reporting on both datasets together, invest in the Data Model approach: one shared Products (or Dates) table makes every future pivot consistent. If you just need this month's figures side by side, GETPIVOTDATA is quicker. Appending is right when the two sources are really one table split by year or region.

Frequently asked questions

Can you merge two pivot tables into one?: Not directly. Combine the source data and build one pivot, or use the Data Model to relate the sources through a shared table.
How do I combine data from two pivot tables in one chart?: Build one pivot from combined or related sources, then insert a PivotChart from it.
Why does my combined pivot repeat the same total on every row?: The row field comes from a table that isn't related to the measure's table. Use the field from the shared dimension table.