Repeating data in a Pivot table

G

Guest

If I have 4 fields in the rows and 2 fields in the columns... how pull the
data so that the fields in the rows are repeated?

For example: if I have a table with country, state & city and I wanted to
see WA repeated for every city in WA... is there a way to do that in the
Pivot table?

Thanks!
 
D

Debra Dalgleish

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill the blanks,
using the technique shown here:

http://www.contextures.com/xlDataEntry02.html
 

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