Repeating Row Fields in a pivot table

G

Guest

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?
 
G

Guest

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?
 
D

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?
Click to expand...
 

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

Similar Threads

Can I transpose data from rows to cols with a formula not pivot ta 1
How to I combine 2 columns from 1 table in a query? 2
Colors and masks for the application contained in a file 3
Pivot Table 1
can't figure out how to add cells in ColB if cells in Col A match. 4
Divide 2 pivot table numbers 3
calculating differences in a pivot table 3
extract row number from Pivot Table Result 1

Top