| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would Like Pivot Table Data on 1 Row instead of Stacked Column
In the pivot, just drag "Data" and drop it over "Total". That should
transform it into the columnar layout that you're after. Success? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Trow" wrote: In the old Excel, when I created a Pivot table, I could select a report template where the data would line up in columns instead of being stacked in the same column. I have selected Modular, Table, Outline and looked at different formats but can not find a fix. I am trying to get the data output for each "row label" across the same row instead of having the data stack on top of each other. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column width of Pivot Table data goes back to default when data refreshed | Excel Discussion (Misc queries) | |||
| How can I create one column (stacked) from a large table of data.. | Excel Worksheet Functions | |||
| Count only if another column has data in Pivot Table? | Excel Worksheet Functions | |||
| Need to Add Column to Data in Pivot Table | Charts and Charting in Excel | |||
| How do I get a pivot table to put data after each row/column. | Excel Discussion (Misc queries) | |||
Threaded Mode
