repeat row labels in pivot table

  • Thread starter Thread starter mhead
  • Start date Start date
M

mhead

I am working on a project where I'll be using data from a pivot table. I want
the row labels to repeat on each line in the tabular format. So rather than
it looking like this:

East
January
February
West
January
February

I want it to look like this:
East January
East February
West January
West February

Any ideas on how to do this? I tried everything I could find and can't get
it to work.
 
That is how Pivot Tables work. If you want it to appear your way, you need
to copy the PT, paste values elsewhere, use this, in exactly this order:

Select the copied values
Edit
Go to..
Special
Blanks
OK
=
Up-Arrow
Ctrl-Enter

Then copy the whole table again and paste values.

HTH,
Bernie
MS Excel MVP
 
One option is to add a column to your data table which concatenates "East"
and "January". Use that for you row.

Regards,
Fred.
 
Back
Top