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

  • Thread starter Thread starter Trow
  • Start date Start date
T

Trow

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot table data layout - columns to rows 1
Pivot Table Help! 1
Pivot table layout that popluates the row label in each row? 3
Can you spread Pivot Table "Value" Fields in seperate columns 3
Office 2007 Pivot Table Display format - Show row headings in each 1
Pivot Table Column Totals - XL2003 5
Pivot Table - 3

Back
Top