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 :D :P :D :P :D