Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeat Label on Pivot Table
Is there any way to get a pivot table to display the label name at the
beginning of each row of data instead of in one row at the top of a grouping? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeat Label on Pivot Table
Not 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 Jim wrote: Is there any way to get a pivot table to display the label name at the beginning of each row of data instead of in one row at the top of a grouping? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeat Label on Pivot Table
as Dave says, no, but you can add a column to the left of the pivot table
and enter a formula that replicate replicates to label =IF(RC[1]="",R[-1]C,RC[1]) Patrick "Jim" wrote in message ... Is there any way to get a pivot table to display the label name at the beginning of each row of data instead of in one row at the top of a grouping? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! repeat row name in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Repeat row data | Excel Discussion (Misc queries) | |||
how do I repeat field value in a pivot table? | Excel Discussion (Misc queries) | |||
How do I get the Pivot Table row labels to repeat? | Excel Discussion (Misc queries) | |||
How do I repeat a value in a pivot table in Excel? | Excel Worksheet Functions |