Can you combine two pivot tables into one?

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
You can create one pivot table from the two data sources using "multiple consolidation ranges".

Select that at the 1st stage of the pivot table wizard
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,727
Members
410,630
Latest member
JFORTH97
Top