I want to build a pivot table based on data in 2 tabs.

The layout of the two tabs a

CC Company Std Inv Concant
23 1 12 10 23-1

I want the pivot to look like:

Concant Std Inv
23-1 12 10

I'm picking the mulptiple consolidation ranges, but then it's not letting me
set the format like in a single range. Can I not do that? I'm using sumifs
to get around using a pivot, but I think a pivot would be much cleaner.

thx.

Hi,

That is not what the multiple consolidation command is all about
unfortunately. You need to either put all the data into one data area, or
use a complex pivot table operation call UNION query.

--
Thanks,
Shane Devenshire


"terri" wrote:

I want to build a pivot table based on data in 2 tabs.

The layout of the two tabs a

CC Company Std Inv Concant
23 1 12 10 23-1

I want the pivot to look like:

Concant Std Inv
23-1 12 10

I'm picking the mulptiple consolidation ranges, but then it's not letting me
set the format like in a single range. Can I not do that? I'm using sumifs
to get around using a pivot, but I think a pivot would be much cleaner.

thx.

what is the multiple consolidation command for?

"ShaneDevenshire" wrote:

Hi,

That is not what the multiple consolidation command is all about
unfortunately. You need to either put all the data into one data area, or
use a complex pivot table operation call UNION query.

--
Thanks,
Shane Devenshire


"terri" wrote:

I want to build a pivot table based on data in 2 tabs.

The layout of the two tabs a

CC Company Std Inv Concant
23 1 12 10 23-1

I want the pivot to look like:

Concant Std Inv
23-1 12 10

I'm picking the mulptiple consolidation ranges, but then it's not letting me
set the format like in a single range. Can I not do that? I'm using sumifs
to get around using a pivot, but I think a pivot would be much cleaner.

thx.