View Single Post
  #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