PivotTables

K

KerryK

Is it possible to repeat the row item on the far left for each row in a
PivotTable?

Kerry K
 
D

Debra Dalgleish

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

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill in the blanks,
using the technique shown here:

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

KerryK

Thanks Debra

I have a client that swears that it can be done but didnt think so.

Have a great day

Regards

Kerry
 
Top