LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
hstijnen
 
Posts: n/a
Default arranging columns in pivot table

Hi,
I've a problem with pivot table. I have a dta table with records (month,
var1, var2, var3). Now I want to create a pivot table with month in rows and
var1, var2 and var3 in columns. Layout like:

month var1 var2 var3
jan 12 23 34
feb 43 23 45
mar ....
....

When I simply drag fields in the wizard the layout becomes like
month
jan var1 12
var2 23
var3 34
feb var1 43
var2 23
var3 45
.......

How can I proceed to the desired result? Strange, occasionally it happened
some time, but I did not know how and why, and I cannot reproduce it.....

Thanks for help
Henk

 
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
? Pivot Table from 3 columns of raw data with headers William Elerding Excel Discussion (Misc queries) 2 April 3rd 06 01:15 PM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
combining 3 columns of same info for a pivot table Julie Excel Worksheet Functions 0 December 15th 04 03:12 PM


All times are GMT +1. The time now is 12:29 PM.

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"