Pivot table reports - repeat the group name on each line

[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

[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

Excel wrote:
> 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


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