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.