| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Office 2007 Pivot Table Display format - Show row headings in each
Is it possible to show the row headings against each line of data in a pivot
table Currently shows Row Label 1 Row Label 2 Value Value Value What I would like to see is Row Label 1 Row Label 2 Value Row Label 1 Row Label 2 Value Row Label 1 Row Label 2 Value I am trying to avoid a lot of cust and paste work when I transpose this data to another file from the pivot table. I know this output format can be obtained from Sort & Subtotal on the raw data but I was hoping if possible to get this from the pivot table. Any and all suggestions welcome. Thankyou for your time. Geoff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Office 07, how do I format my pivot table data? | Excel Worksheet Functions | |||
| Office 2007 and Pivot Table Trouble | Excel Discussion (Misc queries) | |||
| Display top ten items in an Office 2007 pivot table | Excel Discussion (Misc queries) | |||
| Excel 2002: Can Pivot Table show headings beside the row labels ? | Excel Discussion (Misc queries) | |||
| Pivot Table Office 2007 Beta show Top/Bottom features | Excel Discussion (Misc queries) | |||
Threaded Mode
