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

To create the table with a heading on each row, you can copy the table,
and fill the blanks:

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


anonymous wrote:
The standard pivot view looks like this:

Category ID SKU
1400 1501950
1501988
1502526

I'd like to repeat the labels to look like this:

Category ID SKU
1400 1501950
1400 1501988
1400 1502526

Anyone know how to do that? Thanks!


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