Pivot Table - Repeat row data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top