Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jessica
 
Posts: n/a
Default How to get pivot table data columns instead of rows

AWESOME TIP!!!! Thanks, helped a lot!

"Dave Peterson" wrote:

If I understand correctly...

Once you finish the pivottable wizard, you can drag the gray like button labeled
"Data" directly to the right--directly over the word Total.



Apmarg wrote:

When initially creating a pivot table with multiple data values, how can you
have those values appear in separate columns instead of all in one column
with separate row headings saying sum of data1, sum of data2 etc.

I can accomplish what I need by using the report wizard on the resulting
table and then turning off the automatic formatting, but I can't seem to get
this layout without going through this song and dance every time. After
doing this I can't see any difference in the options for the table or
anywhere else.


--

Dave Peterson


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
Rearrange data columns in Pivot Table hedrew3 Excel Discussion (Misc queries) 5 February 5th 05 08:44 AM
Colors of columns after sorting data in the supporting table Booger_Boy Charts and Charting in Excel 6 January 24th 05 03:41 PM
Using Microsoft Query data in a pivot table. slapana Charts and Charting in Excel 0 January 11th 05 06:03 PM
Pivot Table Creating New Columns that Subtract Two Existing Columns den4673 Excel Discussion (Misc queries) 3 December 17th 04 02:31 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM


All times are GMT +1. The time now is 07:09 AM.

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

About Us

"It's about Microsoft Excel"