| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backward pivot table sort of...
I have a spreadsheet similar to this which shows access right for several
depts: Account Dept 1 Dept 2 Dept 3 Dept 4 Salaries READ READ READ READ Supplies WRITE READ WRITE WRITE DEPREC READ READ READ READ I want to end up with: Account Dept Access Salaries 1 READ Salaries 2 READ Salaries 3 READ Salaries 4 READ Supplies 1 WRITE Supplies 1 READ Supplies 1 WRITE Supplies 1 WRITE etc.... Any suggestions????? THANKS!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort top 50 in Pivot table | Excel Discussion (Misc queries) | |||
| sort of pivot table | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| sort in pivot table | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Threaded Mode
