Spreadsheet: 769541d1645586498-sort-data-range-in-stepped-using-formula-power-query-for-grouping-data-graywolf-
Sheet: Expected

Route ID | Types | Vehicle # | Driver Last | Driver First | Monitor Last | Monitor First | Parkout [NAME] | CoOrd PO | Monitor Address | [NAME] | 1st AM Pick Up | Lat/Lon 1st AM Pick Up | Last AM Drop OFF | Lat/Lon Last AM Drop OFF | 1st PM Pick Up | Lat/Lon 1st PM Pick Up | Last PM Drop OFF |  |  | Lat/Lon Last PM Drop OFF
123457 | AM,PM | 2222 | Last Name 02 | First Name 02 | Last Name 01 | First Name 01 | 124 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address |  |  | 43.642760, -79.387067
123458 | AM,PM | 3333 | Last Name 03 | First Name 03 | Last Name 02 | First Name 02 | 125 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address |  |  | 43.642760, -79.387067
123461 | NOON | 6666 | Last Name 06 | First Name 06 | Last Name 03 | First Name 03 | 128 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 128 Address | 43.642760, -79.387067 | 128 Address | 43.642760, -79.387067
123462 | NOON | 7777 | Last Name 07 | First Name 07 | Last Name 04 | First Name 04 | 129 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 129 Address | 43.642760, -79.387067 | 129 Address | 43.642760, -79.387067
123467 | NOON | 13332 | Last Name 12 | First Name 12 |  |  | 134 Address | 43.642760, -79.387067 |  |  | 131 Address | 43.642760, -79.387067 | 131 Address | 43.642760, -79.387067
123468 | NOON | 14443 | Last Name 13 | First Name 13 |  |  | 135 Address | 43.642760, -79.387067 |  |  | 132 Address | 43.642760, -79.387067 | 132 Address | 43.642760, -79.387067
123471 | NOON | 17776 | Last Name 16 | First Name 16 |  |  | 138 Address | 43.642760, -79.387067 |  |  | 133 Address | 43.642760, -79.387067 | 133 Address | 43.642760, -79.387067
123474 | NOON | 21109 | Last Name 19 | First Name 19 |  |  | 141 Address | 43.642760, -79.387067 |  |  | 134 Address | 43.642760, -79.387067 | 134 Address | 43.642760, -79.387067
123475 | NOON | 22220 | Last Name 20 | First Name 20 |  |  | 142 Address | 43.642760, -79.387067 |  |  | 135 Address | 43.642760, -79.387067 | 135 Address | 43.642760, -79.387067
123460 | NOON | 5555 | Last Name 05 | First Name 05 |  |  | 127 Address | 43.642760, -79.387067 |  |  | 127 Address | 43.642760, -79.387067 | 127 Address | 43.642760, -79.387067
123463 | NOON | 8888 | Last Name 08 | First Name 08 |  |  | 130 Address | 43.642760, -79.387067 |  |  | 130 Address | 43.642760, -79.387067 | 130 Address | 43.642760, -79.387067
123456 | AM,PM | 1111 | Last Name 01 | First Name 01 |  |  | 123 Address | 43.642760, -79.387067 |  |  | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 123 Address |  |  | 43.642760, -79.387067
123459 | AM,PM | 4444 | Last Name 04 | First Name 04 |  |  | 126 Address | 43.642760, -79.387067 |  |  | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 126 Address |  |  | 43.642760, -79.387067
123464 | NOON | 9999 | Last Name 09 | First Name 09 |  |  | 131 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 127 Address | 43.642760, -79.387067 | 127 Address |  |  | 43.642760, -79.387067
123465 | NOON | 11110 | Last Name 10 | First Name 10 |  |  | 132 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 128 Address | 43.642760, -79.387067 | 128 Address |  |  | 43.642760, -79.387067
123466 | NOON | 12221 | Last Name 11 | First Name 11 |  |  | 133 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 129 Address | 43.642760, -79.387067 | 129 Address |  |  | 43.642760, -79.387067
123469 | NOON | 15554 | Last Name 14 | First Name 14 |  |  | 136 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 130 Address | 43.642760, -79.387067 | 130 Address |  |  | 43.642760, -79.387067
123470 | NOON | 16665 | Last Name 15 | First Name 15 |  |  | 137 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 131 Address | 43.642760, -79.387067 | 131 Address |  |  | 43.642760, -79.387067
123472 | NOON | 18887 | Last Name 17 | First Name 17 |  |  | 139 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 132 Address | 43.642760, -79.387067 | 132 Address |  |  | 43.642760, -79.387067
123473 | NOON | 19998 | Last Name 18 | First Name 18 |  |  | 140 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 133 Address | 43.642760, -79.387067 | 133 Address |  |  | 43.642760, -79.387067
Route ID | Types | Vehicle # | Driver Last | Driver First | Monitor Last | Monitor First | Parkout [NAME] | CoOrd PO | Monitor Address | [NAME] | 1st AM Pick Up | Lat/Lon 1st AM Pick Up | Last AM Drop OFF | Lat/Lon Last AM Drop OFF | 1st PM Pick Up | Lat/Lon 1st PM Pick Up | Last PM Drop OFF | Lat/Lon Last PM Drop OFF
123457 | AM,PM | 2222 | Last Name 02 | First Name 02 | Last Name 01 | First Name 01 | 124 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067
123458 | AM,PM | 3333 | Last Name 03 | First Name 03 | Last Name 02 | First Name 02 | 125 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067
123461 | NOON | 6666 | Last Name 06 | First Name 06 | Last Name 03 | First Name 03 | 128 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 128 Address | 43.642760, -79.387067 | 128 Address | 43.642760, -79.387067
123462 | NOON | 7777 | Last Name 07 | First Name 07 | Last Name 04 | First Name 04 | 129 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 129 Address | 43.642760, -79.387067 | 129 Address | 43.642760, -79.387067
123475 | NOON | 22220 | Last Name 20 | First Name 20 |  |  | 142 Address | 43.642760, -79.387067 |  |  | 135 Address | 43.642760, -79.387067 | 135 Address | 43.642760, -79.387067
123474 | NOON | 21109 | Last Name 19 | First Name 19 |  |  | 141 Address | 43.642760, -79.387067 |  |  | 134 Address | 43.642760, -79.387067 | 134 Address | 43.642760, -79.387067
123471 | NOON | 17776 | Last Name 16 | First Name 16 |  |  | 138 Address | 43.642760, -79.387067 |  |  | 133 Address | 43.642760, -79.387067 | 133 Address | 43.642760, -79.387067
123468 | NOON | 14443 | Last Name 13 | First Name 13 |  |  | 135 Address | 43.642760, -79.387067 |  |  | 132 Address | 43.642760, -79.387067 | 132 Address | 43.642760, -79.387067
123467 | NOON | 13332 | Last Name 12 | First Name 12 |  |  | 134 Address | 43.642760, -79.387067 |  |  | 131 Address | 43.642760, -79.387067 | 131 Address | 43.642760, -79.387067
123463 | NOON | 8888 | Last Name 08 | First Name 08 |  |  | 130 Address | 43.642760, -79.387067 |  |  | 130 Address | 43.642760, -79.387067 | 130 Address | 43.642760, -79.387067
123460 | NOON | 5555 | Last Name 05 | First Name 05 |  |  | 127 Address | 43.642760, -79.387067 |  |  | 127 Address | 43.642760, -79.387067 | 127 Address | 43.642760, -79.387067
123459 | AM,PM | 4444 | Last Name 04 | First Name 04 |  |  | 126 Address | 43.642760, -79.387067 |  |  | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067
123456 | AM,PM | 1111 | Last Name 01 | First Name 01 |  |  | 123 Address | 43.642760, -79.387067 |  |  | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067
123472 | NOON | 18887 | Last Name 17 | First Name 17 |  |  | 139 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 132 Address | 43.642760, -79.387067 | 132 Address | 43.642760, -79.387067
123473 | NOON | 19998 | Last Name 18 | First Name 18 |  |  | 140 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 133 Address | 43.642760, -79.387067 | 133 Address | 43.642760, -79.387067
123466 | NOON | 12221 | Last Name 11 | First Name 11 |  |  | 133 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 129 Address | 43.642760, -79.387067 | 129 Address | 43.642760, -79.387067
123469 | NOON | 15554 | Last Name 14 | First Name 14 |  |  | 136 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 130 Address | 43.642760, -79.387067 | 130 Address | 43.642760, -79.387067
123470 | NOON | 16665 | Last Name 15 | First Name 15 |  |  | 137 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 131 Address | 43.642760, -79.387067 | 131 Address | 43.642760, -79.387067
123465 | NOON | 11110 | Last Name 10 | First Name 10 |  |  | 132 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 128 Address | 43.642760, -79.387067 | 128 Address | 43.642760, -79.387067
123464 | NOON | 9999 | Last Name 09 | First Name 09 |  |  | 131 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 127 Address | 43.642760, -79.387067 | 127 Address | 43.642760, -79.387067