Show data in columns

F

flyer27

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!
 
H

HmE

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

Sub-Total Column in a pivot table 0
I am using an expression in Access to obtain a year value. 2
Dates In Excel 5
Cell data entering slow! 0
Additional column formula in pivot table 0
Pivot Table Counting Text Data 0
DateDif - End of Month 1
Pivot Table - Row Label Combination 0

Top