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