pivot tables

[Joe]

does anyone know how to format a pivot table so there are
no blank cells? see below
I curently get
type A X 12
Y 20
Z 32
type B X 1
Y 10
Z 27
I would like to get
type A X 12
type A Y 20
type A Z 32
type B X 1
type B Y 10
type B Z 27

 

[Debra Dalgleish]

As answered in microsoft.public.excel.misc --

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

To print the table with a heading on each row, you can create a copy of
the table, and fill the blanks:
http://www.contextures.com/xlDataEntry02.html