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
--
Dave Peterson