Pivot Tables

Guest · Jan 20, 2004

I have two spreadsheets and a pivot on each spreadsheet - the layout is exactly the same yet the output is different. How can I make them exactly alike. One has "data" listed Pric
Uni
Tota
and one has "data" listed Price Unit Tota
How can I get the data to list across instead of down?

Debra Dalgleish · Jan 21, 2004

Drag the Data field button onto the cell which contains the word
'Total', and the fields will be arranged horizontally. There are
instructions here:
http://www.contextures.com/xlPivot02.html

Guest · Jan 21, 2004

Thank you so much! Boy was I frustrated with that yesterday. Works like a champ.

Pivot Tables

Guest

Debra Dalgleish

Guest