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
Solved! Go to 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
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