Sort by repeating values

[Checkers111]

Hi Experts

I have repearting values in a column and i want to sort the data by increasing week bands... see sample data below

0 - 6 Week

0 - 1 Week

7 - 12 Week

106 - 107 Week

107 - 108 Week

108 - 109 Week

109 - 110 Week

110 - 111 Week

111 - 112 Week

122 - 123 Week

13 - 17 Week

13 - 14 Week

14 - 15 Week

150 - 151 Week

15 - 16 Week

[tamerj1 · Accepted solution]

Hi @Checkers111 
You can do the following https://we.tl/t-RB37p59aXq

[tamerj1]

Hi @Checkers111 
Would you please advise the expected result you're looking for?

[Checkers111]

Hi - I was expecting something along the lines of

Sort_Bands = IF('reporting Diagnostics_Weekly_Waiting_MDS' = "0 - 1 Week", 0,

IF('reporting Diagnostics_Weekly_Waiting_MDS' = "1 - 2 Week", 1,

IF('reporting Diagnostics_Weekly_Waiting_MDS' = "2 - 3 Week", 2)))