converting 1 column into several

[ChrisB_dup_72]

I have a data set weather data.  The monthly data is in a few long columns (month, fiscal year, avg temp).  I need to break those long columns up into several short ones (month, FY14 avg temp, FY15 avg temp, etc.).

I'm having trouble doing this.  Any help would be appreciated.

Thank you.

[RodL · Accepted solution]

The Cross Tab tool will do this.

You group by what you want your rows identified (in your case, it sounds like Months).

Then you have your Years as the Header and the Temp as the Values.

Quick example is attached.