Official comment
That data is recognized as text, and as such, is sorted correctly. For example:
1A
10A
11A
2A
...that is the correct order for text values.
I understand that you want:
1A
2A
10A
11A
...but that's not a standard sorting / ordering.
Comment actions