Sort Week Rows Chronologically

[araquecastro]

Hi people,

I have an output file with over 50000 results with several columns. One of the column headers is WEEK with the following result (this is an extract of the final results). 

I want all data to be organize chronologically like the right image. Thanks for the help you can provide.

PD: This is my first post and not acquainted with the way to post tables so far.

[AndrewDMerrill · Accepted solution]

This formula should give you a sorting field:

DateTimeFormat(DateTimeParse(GetWord([WEEK], 0),"%b"),"%m") + Right([WEEK],1)

[araquecastro · Accepted solution]

Hi @AndrewDMerrill this works great!!!. Thank you!!!

[AndrewDMerrill · Accepted solution]

@araquecastroPlease also mark my response as a solution, in order to help others find the solutions that they are looking for!

Happy Solving!!!