Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you repeat outer row field in a pivot table down the row
I want to use the pivot table information in another area, I would like the
outer row to show it's contents on every line, not as 1 line summary (nor a merge), I'd like to see the list repeated down for the field. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you repeat outer row field in a pivot table down the row
You can't do this and keep the pivottable.
But you could copy and paste special values (on another sheet???) and then fill the empty cells with one of the techniques from Debra Dalgleish's site: http://contextures.com/xlDataEntry02.html WINDMILL wrote: I want to use the pivot table information in another area, I would like the outer row to show it's contents on every line, not as 1 line summary (nor a merge), I'd like to see the list repeated down for the field. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I repeat labels in Excel for a pivot table field? | Excel Discussion (Misc queries) | |||
Repeat pivot row or approach to refer to pivot field value... | Excel Discussion (Misc queries) | |||
Sorting of a pivot table by outer and inner row field combinations | Excel Discussion (Misc queries) | |||
how do I repeat field value in a pivot table? | Excel Discussion (Misc queries) | |||
how do i subtotal an outer column in a pivot table? | Excel Worksheet Functions |