Pivot table export data to table format

S

Sue Moore

I have a pivot table with the row heading listed once for
multiple crosstab line items.
I need to use this data for a report that will list the
row heading on each row for each cross tab line item.
Is this possible?
I have tried everything... nothing seems to work.
 
D

Debra Dalgleish

You can't get the heading labels to repeat in the pivot table. You could
copy the pivot table, and paste as values on a different sheet in the
workbook. Then, fill the blank cells, and format the copy of the pivot
table.

There are instructions here for filling in the blank cells:

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