Show data in columns

G

Guest

I am using MS Excel 2007 and trying to create a pivot table that will show
quarterly information in columns. When I drag the quarterly data into the
pivot table, it puts it in rows as shown below:

XYZ Company 1Q 1
2Q 2
3Q 5
4Q 2

I was able to accomplish this task in previous releases of Excel. What do I
need to do?

Thanks!
 
G

Guest

In the right hand pane where you see the fields, have you dragged the
'Quarter' field to the columns box?
 

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

I am using an expression in Access to obtain a year value. 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table file size 4
Pivot table data layout - columns to rows 1
Pivot using 250,000 rows of data in Excel? 1
Column limit for Pivot Table data source 1
Create subtotal column in pivot table 1
Help needed with a Join SQL Query (Access 97) 4

Top