![]() |
Would Like Pivot Table Data on 1 Row instead of Stacked Column
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? |
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? |
All times are GMT +1. The time now is 02:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com