Pivot table reports - repeat the group name on each line
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 |
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 |
All times are GMT +1. The time now is 11:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com