Repeating Row Fields in a pivot table

[maghraby]

Is it possible to get my row fields to repeat with every row instead of
having the row field appear once as a header for all related data?
example:
in a sales table by area:
ROWS COLOMS
Area1 11111
22222
31142
Area2 45354
54534
===================
Can I get "Area1" to repeat with all its sales values and so Area2 too?

 

[Max]

Try Debra Dalgleish's page for
some nice ideas on filling in the blank cells:
http://www.contextures.com/xlDataEntry02.html
Fill Blank Cells
Fill Blank Cells Programmatically

 

[maghraby]

Thank Max for this.
But this solution is only applicable if i copy my pivot table data and paste
in a new sheet which is not viewed as a pivot table. Is there a way to do
this as an option for pivot tables?

 

[Dave Peterson]

Nope.

Thank Max for this.
But this solution is only applicable if i copy my pivot table data and paste
in a new sheet which is not viewed as a pivot table. Is there a way to do
this as an option for pivot tables?