To arrange the fields horizontally, drag the Data field button onto the
cell that contains the word 'Total'.

There's a picture he

http://www.contextures.com/xlPivot02.html


lyric2002 wrote:
Is there a way to design a pivot table to show multiple columns per unique
row identifier rather then multiple rows? I am trying to have my the report
go laterally rather then vertically to reduce page size. Thanks in advance.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html