Sorting norwegian language

Copper Contributor

In the norwegian language we have the extra letters æ,ø and å which are sorted at the end (after z). But - 'aa' can also be used to represent å. 

My problem is that I have a list of values that happens to have to adjacent instances of a - and I want them to be sorted as such and not as å (aa) 

 

So, I want to sort the values like this

AATEST

NEW

TEST

 

What actually happens is

NEW

TEST

AATEST

 

Any suggestions? 

0 Replies