Pivot table

[Guest]

Hi,
I am making a pivot table in Excel; the data is pulled from SQL Server. the format is as following
Month 1 10 11 12 2 3 4 5 6 7 8 9
============================================
Cat1
Cat2

My question is that the order of month is off; obviously the Excel took them as string and put them into order by string. How do I fix the order of month on the column header, and make it 1 to 12. thanks

 

[Beto]

Hi,
I am making a pivot table in Excel; the data is pulled from SQL Server. the format is as following
Month 1 10 11 12 2 3 4 5 6 7 8 9
============================================
Cat1
Cat2

My question is that the order of month is off; obviously the Excel took them as string and put them into order by string. How do I fix the order of month on the column header, and make it 1 to 12. thanks

Hi,
One solution, maybe not the best one, is to use the macro recorder to
record your steps while reorganizing this table manually. How? press
Right-Click on the month number, then reorder, and choose where you want
it to go.

After getting the table as you want it, stop recording and see the
macro. If anything is not needed just erase it.

Regards,

 

[Guest]

thank you Beto
I tried to do the way you said, but, where is the 'reorder' button; there is only 'order' button, and it is graied out.
Could you be more specific. thanks