LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Show data in columns

I am using MS Excel 2007 and trying to create a pivot table that will show
quarterly information in columns. When I drag the quarterly data into the
pivot table, it puts it in rows as shown below:

XYZ Company 1Q 1
2Q 2
3Q 5
4Q 2

I was able to accomplish this task in previous releases of Excel. What do I
need to do?

Thanks!
 
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
Show all columns in Excel Jenny O17 Excel Discussion (Misc queries) 1 November 13th 06 02:19 PM
Use mixed references to show row data as columns in another book HNK Excel Discussion (Misc queries) 6 July 25th 06 12:07 AM
show sereral columns of data field in pivot table Linda New Users to Excel 3 February 18th 06 02:43 AM
pivot tables-drop data in, how to make it show as columns instead Alicia Excel Discussion (Misc queries) 1 February 15th 06 03:31 PM
MSQuery won't show columns CLR Excel Discussion (Misc queries) 1 August 5th 05 07:18 PM


All times are GMT +1. The time now is 01:21 PM.

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"