Multiple Consolidation Ranges

[Freshman]

Dear experts,

I want to create a pivot table by using Multiple Consolidation Ranges.
According to general creating procedure, a pivot table comes out with the
first column of the source data tables as "Row" and the other columns as
"Column" in the layout. Actually, this layout of the pivot table is not what
I want. I want the data in first two columns will display as "Row" and the
other columns as "Column". However, even I drag the wanted heading from
"Column" side to "Row" side, the heading will display only and not the
content. Anyway, I cannot make it. Is there any limitation of doing this or
there are some other ways to make it? Please kindly teach me.

Thanks & regards.

 

[Debra Dalgleish]

The pivot table that's created from multiple consolidation ranges is
very limited. Perhaps you could create a new column at the start of your
source data, and use a formula to combine the data from the two columns
that you want to display as rows. For example:

=B2&"--"&C2

Then, both values will appear in the Row area of the pivot table that
you create.

 

[Freshman]

Thanks, Debra.

The pivot table that's created from multiple consolidation ranges is
very limited. Perhaps you could create a new column at the start of your
source data, and use a formula to combine the data from the two columns
that you want to display as rows. For example:

=B2&"--"&C2

Then, both values will appear in the Row area of the pivot table that
you create.