repeat row labels in pivot table


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.
 
Ad

Advertisements

B

Bernie Deitrick

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
 
Ad

Advertisements

F

Fred Smith

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

Regards,
Fred.
 

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