Getting the drop down in a horizontal view instead of vertical view

[#1]

Hi All,

I have fiels like year,Quarter and spend.

I want this to be like

year

TotalSpend Quater1Spend Quarter2Spend

2008

I tried pivot table but i get only in a vertical fashion but how to get in a horizontal fashion.

Please help.

Thanks.

[Oleg_Troyansky · Accepted solution]

Drag your Quarters across by dragging the heading of the field to the right until the blue line becomes horizontal.

[#3]

It worked.Thanks a lot Oleg.