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,
paste it as values in another location, and fill the blanks:

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


robbie wrote:
Hi

my pivot is set up like this

code product qty
0204 a 30
b 35
0205 a 30
b 35

I would like it to read
code product qty
0204 a 30
0204 b 35
0205 a 30
0205 b 35

help please





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