Custom sort of a column

[Anonymous]

Hi All,

Is there a way i can custom sort the order of column "Country Name" below into the order i need instead of sorting A-Z or Z-A?

Company Name	Jan	Feb
ABC	10	70.9
BCD	0.2	9
DHQ	8.8	89
RSL	0	15
VUJ	86	197

The order required is 

Company Name	Jan	Feb
DHQ	8.8	89
ABC	10	70.9
VUJ	86	197
BCD	0.2	9
RSL	0	15

Please let me know your inputs.

Thanks!

[LivioLanzo · Accepted solution]

Hi @Anonymous

you can add an extra column to the data where you assign 1 to DHQ, 2 to ABC etc and then use the 'Sort By Column' feature from the 'Modeling' tab.