Alphabet sorting

[Jake5]

Hello,

I have an output file I'm trying to sort ascending on a column that basically lists the alphabet and after 'Z' it transitions to AA, BB, CC, etc. Right now, the sort is placing the double letters at the top, showing as..

AA

BB

CC

A

B

C

Ideally, I'd like the double letter values to sort after the single letter values such as...

X

Y

Z

AA

BB

CC

Is there a way to accomplish this?

[DataNath · Accepted solution]

@Jake5 you could use an approach like this, where you measure the length of the field to get a count which you then sort on before sorting alphabetically on the data field itself:

[binu_acs · Accepted solution]

@Jake5 One way of doing this

[Jake5]

Thank you both!