ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Would Like Pivot Table Data on 1 Row instead of Stacked Column (https://www.excelbanter.com/excel-discussion-misc-queries/249307-would-like-pivot-table-data-1-row-instead-stacked-column.html)

Trow

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?

Max

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