I have two pivot tables on the same worksheet, but they are side-by-side. They were originally built like this because we kept running into Pivot Tables overlapping each other which was a problem.
So my question - is it possible to have the two different pivot tables in the same table (they have the exact same columns, but their row labels are different)?
Ideally I want:
Row Label 1 (grouped in Section 1)
Row Label 2 (grouped in Section 2)
Thank you in advance.
I am using MS Excel 2010.
So my question - is it possible to have the two different pivot tables in the same table (they have the exact same columns, but their row labels are different)?
Ideally I want:
Row Label 1 (grouped in Section 1)
Row Label 2 (grouped in Section 2)
Thank you in advance.
I am using MS Excel 2010.