Yeah, that's what I meant. <g Thanks!

Dave Peterson wrote:
But that copy of the table should be pasted as values--so it won't be a
pivottable anymore.

Debra Dalgleish wrote:

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




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