Help transforming salary ranges in descending order

[arundaka03]

Hi everyone. 

I need to transform a list of salary ranges so they appear in descending order and have 'Prefer not to say' at the bottom. I have attached the Excel of the table and it is column 'My current salary is...' that needs transforming. 

Is there a way I can transform the column so they appear in the following order:

My current salary is....
Over £200,000
£180000 - 199,999
£160,000 - 179,999
£140,000 - 159,999
£120,000 - 139,999
£100,000 - 119,999
Under £20000
Prefer not to answer

Thanks in advance,

KA

[IraWatt]

Hey @arundaka03,

Here is one way to do this:

My approach was to get the salary as a number (not text) then sort by that. I got the number using regex then use a formula to make it a number.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[MarqueeCrew]

@arundaka03 ,

i would create a SORT field that is numeric based upon the values.  Another approach is to define the values with a leading number.  Then at the end of your process use a substring function to skip the number and update the field. 

cheers,

 mark 

[grazitti_sapna · Accepted solution]

@arundaka03, give this a try.

Thanks!