Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get labels to repeat in a pivot table? | Excel Worksheet Functions | |||
PIvot Table - Repeat Row Labels | Excel Discussion (Misc queries) | |||
How do I get the Pivot Table row labels to repeat? | Excel Discussion (Misc queries) | |||
How can I repeat labels in a Pivot Table? | Excel Worksheet Functions | |||
How do I repeat labels in a Pivot Table | Excel Discussion (Misc queries) |