I have a spreadsheet that I am trying to custom sort, but it will not sort the way I've asked it to. For example the first column is a number, which I need for it to sort first. The second column is:
1 W1/2
2 W1/2
3 W1/2
1 E1/2
2 E1/2
3 E1/2
I need them to sort as it reads above, as of right now they read
1 W1/2
1 E1/2
2 W1/2
2 E1/2
3 W1/2
3 E1/2
I can not for the life of me get it to sort the first way. Any help?? Thanks!
Bookmarks