Spreadsheet: 860058d1708308103-changing-transport-route-transport-route-pq-dj-updated-wongsiuon-
Sheet: Result Truck Route

The location A-L will rearrnage, then the recievd/Delivery jobs will also change accordingly. |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | Contact Number | Received | Delivered
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] ;[NAME] | Food;Chair | Cabinet
A | à | C | à | B | à | E | à | F | à | D |  |  |  | B | [NAME] ;[NAME] | Food;Chair;Cabinet | Goods;Chair
G | à | H | à | I | à | J | à | K | à | L |  |  |  | C | [NAME] ;[NAME] | Drinks;Chair;Cabinet | Food;Chair;Cabinet
 |  |  |  |  |  |  |  |  |  |  |  |  |  | D | [NAME] | Food;Chair | Cabinet
Best Result, it is best if the space line will be omitted according to no. of jobs |  |  |  |  |  |  |  |  |  |  |  |  |  | E | [NAME] | Food;Chair;Cabinet | Goods;Chair
Locataion | A |  |  |  |  | Locataion | G |  |  |  |  |  |  | F | Sandy | Drinks;Chair;Cabinet | Food;Chair;Cabinet
Contact | [NAME] |  |  |  |  | Contact | [NAME] |  |  |  |  |  |  | G | [NAME] | Food;Chair | Cabinet
 | [NAME] |  |  |  |  | Recived | Food |  |  |  |  |  |  | H | [NAME] | Food;Chair;Cabinet | Goods;Chair
Recived | Food |  |  |  |  |  | Chair |  |  |  |  |  |  | I | Carol | Drinks;Chair;Cabinet | Food;Chair;Cabinet
 | Chair |  |  |  |  | Delivery | Cabinet |  |  |  |  |  |  | J | [NAME] | Food;Chair | Cabinet
Delivery | Cabinet |  |  |  |  | Locataion | H |  |  |  |  |  |  | K | Eddie | Food;Chair;Cabinet | Goods;Chair
Locataion | C |  |  |  |  | Contact | [NAME] |  |  |  |  |  |  | L | [NAME] | Drinks;Chair;Cabinet | Food;Chair;Cabinet
Contact | [NAME] |  |  |  |  | Recived | Drinks
 | [NAME] |  |  |  |  |  | Chair
Recived | Drinks |  |  |  |  |  | Cabinet
 | Chair |  |  |  |  | Delivery | Food
 | Cabinet |  |  |  |  |  | Chair |  |  |  |  |  |  | If you want a new order just fill the column 'O' bellow
Delivery | Food |  |  |  |  |  | Cabinet |  |  |  |  |  |  | New order
 | Chair |  |  |  |  | Locataion | I |  |  |  |  |  |  | Location | contact number | Received | Delivered
 | Cabinet |  |  |  |  | Contact | Carol |  |  |  |  |  |  | A
Locataion | B |  |  |  |  | Recived | Food |  |  |  |  |  |  | C
Contact | [NAME] |  |  |  |  |  | Chair |  |  |  |  |  |  | B
 | [NAME] |  |  |  |  |  | Cabinet |  |  |  |  |  |  | E
Recived | Food |  |  |  |  | Delivery | Goods |  |  |  |  |  |  | F
 | Chair |  |  |  |  |  | Chair |  |  |  |  |  |  | D
 | Cabinet |  |  |  |  | Locataion | J |  |  |  |  |  |  | G
Delivery | Goods |  |  |  |  | Contact | [NAME] |  |  |  |  |  |  | H
 | Chair |  |  |  |  | Recived | Food |  |  |  |  |  |  | I
Locataion | E |  |  |  |  |  | Chair |  |  |  |  |  |  | J
Contact | [NAME] |  |  |  |  |  | Cabinet |  |  |  |  |  |  | K
Recived | Food |  |  |  |  | Delivery | Goods |  |  |  |  |  |  | L
 | Chair |  |  |  |  |  | Chair
 | Cabinet |  |  |  |  | Locataion | K
Delivery | Goods |  |  |  |  | Contact
 | Chair |  |  |  |  | Recived | Drinks
Locataion | F |  |  |  |  |  | Chair
Contact | Sandy |  |  |  |  |  | Cabinet
Recived | Drinks |  |  |  |  | Delivery | Food
 | Chair |  |  |  |  |  | Chair
 | Cabinet |  |  |  |  |  | Cabinet
Delivery | Food |  |  |  |  | Locataion | L
 | Chair |  |  |  |  | Contact | [NAME]
 | Cabinet |  |  |  |  | Recived | Food
Locataion | D |  |  |  |  |  | Chair
Contact | [NAME] |  |  |  |  | Delivery | Cabinet
Recived | Food
 | Chair
Delivery | Cabinet