Pivot table
 

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

Pivot table
 

wd1153 wrote:

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Pivot table
 

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