Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Would Like Pivot Table Data on 1 Row instead of Stacked Column

10 views
Skip to first unread message

Trow

unread,
Nov 24, 2009, 5:40:01 PM11/24/09
to
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

unread,
Nov 24, 2009, 10:27:01 PM11/24/09
to
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
---
0 new messages