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?
 
Top