Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table - display all labels (i.e: do not summarise) how to?
Dear all, i am pivotting large lists of equipment required for a construction
project, and cannot get excel to display labels correctly. i.e: if i have a room, with 2 items in it, the pivot table will only display the room label once, below is a simplified summary of my pivotted data: Room: Item: Quantity: 1a Desk 1 1b Desk 2 Chair 1 1c Desk 1 therefore, i must copy the room code "1b" down into the empy cell next to "chair". this is proving so time consuming when dealing with thousands of items. i can get excel to merge labels (by ticking 'merge labels') but i cannot get excel to copy labels into blanks (if there is such a command) please help. Regards, Martin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table - display all labels (i.e: do not summarise) how to?
Not possible to do this and keep it a pivottable.
I copy the pivottable to a new worksheet and paste|special values. That copy is no longer a pivottable, but I can do anything I want to the data. Including following these techniques from Debra Dalgleish's site: http://contextures.com/xlDataEntry02.html Martin wrote: Dear all, i am pivotting large lists of equipment required for a construction project, and cannot get excel to display labels correctly. i.e: if i have a room, with 2 items in it, the pivot table will only display the room label once, below is a simplified summary of my pivotted data: Room: Item: Quantity: 1a Desk 1 1b Desk 2 Chair 1 1c Desk 1 therefore, i must copy the room code "1b" down into the empy cell next to "chair". this is proving so time consuming when dealing with thousands of items. i can get excel to merge labels (by ticking 'merge labels') but i cannot get excel to copy labels into blanks (if there is such a command) please help. Regards, Martin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get labels to repeat in a pivot table? | Excel Worksheet Functions | |||
PIvot Table - Repeat Row Labels | Excel Discussion (Misc queries) | |||
How do I get the Pivot Table row labels to repeat? | Excel Discussion (Misc queries) | |||
How can I repeat labels in a Pivot Table? | Excel Worksheet Functions | |||
How do I repeat labels in a Pivot Table | Excel Discussion (Misc queries) |