Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
? Pivot Table from 3 columns of raw data with headers | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |