Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lyric2002
 
Posts: n/a
Default 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.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

  #3   Report Post  
Barb R.
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple MS Access table sources for pivot table fbj Excel Discussion (Misc queries) 5 August 15th 05 04:41 PM
How to have multiple columns in pivot table data area? mitch1962 Excel Worksheet Functions 0 February 24th 05 08:42 AM
How to have multiple columns in pivot table data area? mitch1962 Excel Worksheet Functions 1 February 24th 05 02:22 AM
Pivot Table combining multiple columns Pete Petersen Excel Discussion (Misc queries) 1 January 13th 05 08:56 PM
ability to auto file column(s) on a pivot table km Excel Worksheet Functions 1 December 20th 04 10:39 PM


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"