How to merge 2 pivot tables in Excel

[Rao's]

Sponsored Links

Hi. I want to merge 2 pivot tables into one pivot, keeping the structure. I have 2 pivot tables with the same rows and columns and I want to keep the same format the others have. I have tried with consolidated ranges but the layout and the results are very different from the original pivots. Do you know any other solution to this problem? Thanks

[Hollyn]

You just try this may it will help you to merge the two different pivot tables. So for that you just have to move the pivot table to another sheet. So to do this you have to make the use of the PivotTable Tools TAB, so this will be available when you make the selection of pivot table. With the use of the Tools TAB, you can have more than one pivot table on a worksheet.

[Koman]

You can do this by creating the vba, so try to make the use of the vba for merging the 2 pivot tables in Excel. This is possible only with the vba.