Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Repeat row data
I have a pivot table with multiple rows. Is it possible to show the row value
repeated on each row, rather one label for each set of data with that value. For example currently the item 'Product 1' is only displayed once and I would like it repeated on each row. Product 1 - Customer 1 - Jan - 100 Product 1 - Customer 2 - Jan - 99 Product 1 - Customer 3 - Jan - 80 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Repeat row data
Not within the actual pivot, but possible on a pasted special as values copy
of it Try Debra Dalgleish's page for ways to fill in the col blanks: http://www.contextures.com/xlDataEntry02.html Excel -- Data Entry -- Fill Blank Cells Fill Blank Cells Fill Blank Cells Programmatically (Sub FillColBlanks() by Dave Peterson) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Lyra" wrote: I have a pivot table with multiple rows. Is it possible to show the row value repeated on each row, rather one label for each set of data with that value. For example currently the item 'Product 1' is only displayed once and I would like it repeated on each row. Product 1 - Customer 1 - Jan - 100 Product 1 - Customer 2 - Jan - 99 Product 1 - Customer 3 - Jan - 80 |
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 do I repeat a value in a pivot table in Excel? | Excel Worksheet Functions | |||
How can I repeat labels in a Pivot Table? | Excel Worksheet Functions |