Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
"Cannot Group That Selection" in a Pivot Table. | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
How do I repeat labels in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |