I would like to sort the table by two columns: first by street name; then second sort by street number (2nd sort of the previous sort) so that the list looks like the following:
1 Spruce Rd
2 Spruce Rd
3 Spruce Rd
5 Spruce Rd
11 Spruce Rd
127 Spruce Rd
2011 Spruce Rd
Not like the following:
1 Spruce Rd
11 Spruce Rd
127 Spruce Rd
2 Spruce Rd
2011 Spruce Rd
3 Spruce Rd
5 Spruce Rd
Thanks for your help