Pivot Table - Repeat row data


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
 
Ad

Advertisements

G

Guest

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)
 

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