ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table reports - repeat the group name on each line (https://www.excelbanter.com/excel-discussion-misc-queries/98445-pivot-table-reports-repeat-group-name-each-line.html)

Excel

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


Debra Dalgleish

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