Pivot table reports - repeat the group name on each line

E

Excel

When you run a pivot table of employees and their software licesnces,
the report will list the name once and the licenses on several lines
without rtepeating the employee's name. I want the name repeated for
multiple licenses because I want to use that data for another
spreadsheet. How can I get Excel to repeat the names? Thanks
 
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 the blanks,
using the technique shown here:

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