| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeating names in row fields of a pivot table
Is there a way to get the pivot table to automatically repeat the names in
the outer row fields? This way one could use the resulting pivot table as a database. Normally you have to manually copy the names to the blank cells below the name in the outer row fields. In the below example I would like EAST to show up in every cell below it, same with WEST Region Salesperson EAST Buchanan Davolio Dodsworth Suyama WEST Buchanan Davolio |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Repeats Names in multiple rows | Excel Discussion (Misc queries) | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
