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