I have a worksheet with 10 columns of data but I want to sort the data by route and then by stop order:
This is just the first 2 columns but it is possible to apply a sort in excel to give me my results by route and then stop order - like the first one in green, this is correct then it goes out of sequence?
I have no idea what this type of sort would be called so struggling to find any information online.
Thank you
Sara
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Route | Stop | ||
2 | 1 | 1 | ||
3 | 1 | 2 | ||
4 | 1 | 3 | ||
5 | 1 | 4 | ||
6 | 2 | 1 | ||
7 | 2 | 3 | ||
8 | 2 | 2 | ||
9 | 2 | 4 | ||
10 | 3 | 1 | ||
11 | 3 | 3 | ||
12 | 3 | 2 | ||
13 | 3 | 4 | ||
14 | 4 | 3 | ||
15 | 4 | 2 | ||
16 | 4 | 1 | ||
17 | 5 | 1 | ||
18 | 5 | 2 | ||
19 | 5 | 2 | ||
20 | 5 | 2 | ||
Sheet1 |
This is just the first 2 columns but it is possible to apply a sort in excel to give me my results by route and then stop order - like the first one in green, this is correct then it goes out of sequence?
I have no idea what this type of sort would be called so struggling to find any information online.
Thank you
Sara