PivotTables
 

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

Kerry K

PivotTables
 

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 he

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

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

PivotTables
 

Thanks Debra

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

Have a great day

Regards

Kerry

"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 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 he

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

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html