Looking to change pivot table orientation

  • Thread starter Thread starter eggman2001
  • Start date Start date
E

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.
 
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.
 
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 -
Click to expand...

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
 
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
Click to expand...

Oh Great. Thank you!
 
Back
Top