Repeating data in a Pivot table

[Alicia]

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!

[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

Alicia wrote:
> 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?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html