Repeat Label on Pivot Table

J

Jim

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?
 
D

Dave Peterson

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
 
P

Patrick Molloy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top