Show data in columns

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
In the right hand pane where you see the fields, have you dragged the
'Quarter' field to the columns box?
 
Back
Top