repeat row labels in pivot table
 

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.

repeat row labels in pivot table
 

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




"mhead" wrote in message
...
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.

repeat row labels in pivot table
 

One option is to add a column to your data table which concatenates "East"
and "January". Use that for you row.

Regards,
Fred.

"mhead" wrote in message
...
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.