Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have columns that consist of CustomerName, Type, January, February, March etc. The rows have budgeted numbers for the year under each month for each customer. I want to have my data so that it lists Customer Type Month Amount Joe Smith A Jan $400 Joe Smith A Feb $500 joe Smith A March $300 For each client. I tried doing a pivot table but am having trouble. I am not trying to calculate anything just shift the data from columns to row. Thanks, Chuck -- Chuck W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Too many rows or columns in pivot table | Excel Discussion (Misc queries) | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
Too many rows or columns in my pivot-table | Excel Discussion (Misc queries) | |||
Putting data into pivot tables in columns not rows. | Excel Discussion (Misc queries) | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |