Re arrange month wise rows

[areeba]

Hi ,

I want to re arrange column 'Name2' according to month wise like from Jan to dec and rest 2 columns respectively.

Can somebody help?

Regards

Areeba

[afv2688 · Accepted solution]

Hello @areeba ,

you can use the following formula to transform the mont into a numeric value to then sort afterwards:

DateTimeMonth(DateTimeParse([Name2],'%b'))

Regards

[areeba]

Hi @afv2688 

Thank you for the solution but my final output should look exact like this:

note: Please ignore decimals in Jul values.

Can you help ?

Areeba

[areeba]

Hi @afv2688 

Thanks , it worked. 🙂

Please ignore my above post.

Thanks

Areeba