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?

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

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?