Looking to change pivot table orientation

[eggman2001]

I'm using Excel 2007 and have a pivot table with many values and no
row labels. This is making the pivot table very wide - like 15 columns
and I'm wondering if there's a way to switch the orientation so that
it would be 2 columns and 15 rows instead of 2 rows and 15 columns.

 

[Bob Umlas]

Just move the fields around in the field list

 

[eggman2001]

Do you mean moving them up or down? That simply changes the order of
the fields and doesn't change the table from a horizontal to vertical
orientation.

 

[anandydr]

Do you mean moving them up or down? That simply changes the order of
the fields and doesn't change the table from a horizontal to vertical
orientation.




- Show quoted text -

Move the column heading in Row lables to Column lables and the column
heading in Column lable to Row lables. (Click anywhere in pivot table
and these will appear in right bottom corner interchange values)

HTH,
Anand

 

[eggman2001]

Move the column heading in Row lables to Column lables and the column
heading in Column lable to Row lables. (Click anywhere in pivot table
and these will appear in right bottom corner interchange values)

HTH,
Anand

Oh Great. Thank you!