Combining 2 pivot tables
 

Hi,

I have two pivot tables, and I would like to consolidate the data into one.
Both tables are linked to the same source, and have identical data formats.
However the final row for each table has a different name.

Any ideas how I can get this data into a single pivot table?

Thanks,

RA

What's in the final row of each table?

RestlessAde wrote:
Hi,

I have two pivot tables, and I would like to consolidate the data into one.
Both tables are linked to the same source, and have identical data formats.
However the final row for each table has a different name.

Any ideas how I can get this data into a single pivot table?

Thanks,

RA


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html