|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 26th, 2005, 03:51 PM
|
|||
|
|||
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
May 26th, 2005, 05:47 PM
|
|||
|
|||
|
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
May 26th, 2005, 05:53 PM
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot table, dynamic data formula | Excel GuRu | General Discussion | 3 | May 3rd, 2005 10:45 PM |
| Pivot Table Problems | Rachel Gonsior | General Discussion | 3 | March 21st, 2005 07:24 PM |
| How to have multiple columns in pivot table data area? | mitch1962 | Worksheet Functions | 2 | February 24th, 2005 07:42 AM |
| Creating pivot table with multiple ranges in excel | Phil Policelli | Worksheet Functions | 2 | September 19th, 2004 05:07 PM |
| Pivot Table with Duplicate Field Names | Michael Bayuk | Worksheet Functions | 5 | March 15th, 2004 07:32 AM |
Linear Mode
