View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot table reports - repeat the group name on each line

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 he

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