Multiple columns in a pivot table
 

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.

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

http://www.microsoft.com/office/comm...3-4f9c2db9f931

Take a look at that link and see if it helps you.


"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.