Repeating Row Fields in a pivot table
 

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?

Repeating Row Fields in a pivot table
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"maghraby" wrote:
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?

Repeating Row Fields in a pivot table
 

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?

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"maghraby" wrote:
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?

Repeating Row Fields in a pivot table
 

Nope.


maghraby wrote:

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?

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"maghraby" wrote:
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?



--

Dave Peterson