i'm trying to sort the numbers stored for a contact in a certain way, but it seems that it is sorting the field randomly.
example:
company Y has 3 locations A, B, & C
each location has 2 numbers X1, & X2
i'm trying to sort them this way:
Contact: Y
A1
A2
B1
B2
C1
C2
but as i mentioned, it's being sorted another way which seems random to me!
HELP
BTW: Full marks to the first correct answer :P
PS: feel free to substitude your answer with Trains, Time Tables, & Speeds 😃 :P 😃 :P 😃