Spreadsheet: 750669d1633583208-need-formula-for-blank-out-duplicate-cells-based-on-value-that-is-changes-in-another-colum-repair-report
Sheet: Data

Ref. | Document Date | Job Number | Job Description | Primary Asset ID | Secondary Asset ID | Driver ID | Driver Name | Repair Category | Repair Location | Repair Type | Repair Required | Start Date | Release Date
BRK/REN/0032/1012 | 2020-07-25 15:29:00 | ‭0032‬ | RENTAL DIVISION | FB-003 |  | ‭‬ |  | Workshop Repair Order |  | BODY | BODY PAINT FADED | 2020-07-25 00:00:00 | 2020-07-25 00:50:00
BRK/REN/0032/1012 | 2020-07-25 15:29:00 | ‭0032‬ | RENTAL DIVISION | FB-003 |  | ‭‬ |  | Workshop Repair Order |  | BRAKES | BRAKE LINER CHECK | 2020-07-25 00:00:00 | 2020-07-25 00:50:00
BRK/REN/0032/1012 | 2020-07-25 15:29:00 | ‭0032‬ | RENTAL DIVISION | FB-003 |  | ‭‬ |  | Workshop Repair Order |  | [NAME] | GENERAL CHECK UP | 2020-07-25 00:00:00 | 2020-07-25 00:50:00
BRK/REN/0032/1012 | 2020-07-25 15:29:00 | ‭0032‬ | RENTAL DIVISION | FB-003 |  | ‭‬ |  | Workshop Repair Order |  | [NAME] | GREASING | 2020-07-25 00:00:00 | 2020-07-25 00:50:00
BRK/REN/0032/1012 | 2020-07-25 15:29:00 | ‭0032‬ | RENTAL DIVISION | FB-003 |  | ‭‬ |  | Workshop Repair Order |  | [NAME] | WASHING | 2020-07-25 00:00:00 | 2020-07-25 00:50:00
BRK/REN/0032/19143 | 2021-06-23 14:10:00 | ‭0032‬ | RENTAL DIVISION | TH-2021 | TR-370 | ‭36037‬ |  | Breakdown Repair |  | TYRES | TYRE BURST (POSITION) | 2021-06-23 14:10:00 | 2021-06-23 14:10:00
BRK/REN/0032/23831 | 2021-08-17 22:45:00 | ‭0032‬ | RENTAL DIVISION | TH-1945 | TR-390 | ‭39719‬ |  |  |  |  |  | 2021-08-17 22:45:00 | 2021-08-17 22:45:00
BRK/REN/0032/1 | 2020-07-01 13:00:00 | ‭0032‬ | RENTAL DIVISION | TH-1975 |  | ‭‬ |  | Workshop Repair Order |  | WHEEL | WHEEL BOLT BROKEN ( POSITION) | 2020-07-01 00:00:00 | 2020-07-01 14:45:00
BRK/REN/0032/10 | 2020-07-01 19:28:00 | ‭0032‬ | RENTAL DIVISION | TH-1941 | TR-508 | ‭35462‬ |  | Workshop Repair Order |  | ENGINE | F1 SERVICE | 2020-07-01 19:35:00 | 2020-07-01 22:46:00
BRK/REN/0032/100 | 2020-07-04 15:01:00 | ‭0032‬ | RENTAL DIVISION | TH-1955 | TR-532 | ‭35606‬ |  | Workshop Repair Order |  | TYRES | TYRE PUNCTURE ( POSITION) | 2020-07-04 03:06:00 | 2020-07-04 15:33:00
BRK/REN/0032/1000 | 2020-07-25 11:20:00 | ‭0032‬ | RENTAL DIVISION | TH-2006 | TR-410 | ‭17525‬ |  | Workshop Repair Order |  | CABIN | CABIN LOCK | 2020-07-25 11:25:00 | 2020-07-25 14:08:00
BRK/REN/0032/1000 | 2020-07-25 11:20:00 | ‭0032‬ | RENTAL DIVISION | TH-2006 | TR-410 | ‭17525‬ |  | Workshop Repair Order |  | [NAME] | GENERAL CHECK UP | 2020-07-25 11:25:00 | 2020-07-25 14:08:00
BRK/REN/0032/10000 | 2021-02-19 17:00:00 | ‭0032‬ | RENTAL DIVISION | TH-1923 | TR-216 | ‭38853‬ |  | Workshop Repair Order |  | [NAME] | WASHING AND GREASING | 2021-02-19 17:00:00 | 2021-02-19 21:13:00
BRK/REN/0032/10000 | 2021-02-19 17:00:00 | ‭0032‬ | RENTAL DIVISION | TH-1923 | TR-216 | ‭38853‬ |  | Workshop Repair Order |  | TYRES | ALL TYRES AIR PRESSURE TO BE CHECK | 2021-02-19 17:00:00 | 2021-02-19 21:13:00
BRK/REN/0032/10001 | 2021-02-19 17:03:00 | ‭0032‬ | RENTAL DIVISION | TH-1931 | TR-580 | ‭38725‬ |  | Workshop Repair Order |  | ENGINE | ENGINE OIL TOP UP | 2021-02-19 17:02:00 | 2021-02-19 19:08:00
BRK/REN/0032/10001 | 2021-02-19 17:03:00 | ‭0032‬ | RENTAL DIVISION | TH-1931 | TR-580 | ‭38725‬ |  | Workshop Repair Order |  | [NAME] | WASHING AND GREASING | 2021-02-19 17:02:00 | 2021-02-19 19:08:00
BRK/REN/0032/10001 | 2021-02-19 17:03:00 | ‭0032‬ | RENTAL DIVISION | TH-1931 | TR-580 | ‭38725‬ |  | Workshop Repair Order |  | TYRES | ALL TYRES AIR PRESSURE TO BE CHECK | 2021-02-19 17:02:00 | 2021-02-19 19:08:00
BRK/REN/0032/10001 | 2021-02-19 17:03:00 | ‭0032‬ | RENTAL DIVISION | TH-1931 | TR-580 | ‭38725‬ |  | Workshop Repair Order |  | TYRES | UNEVEN TYRE WEAR ( POSITION) | 2021-02-19 17:02:00 | 2021-02-19 19:08:00
BRK/REN/0032/10002 | 2021-02-19 17:20:00 | ‭0032‬ | RENTAL DIVISION | TH-2022 | TR-384 | ‭36620‬ |  | Workshop Repair Order |  | [NAME] | GENERAL CHECK UP | 2021-02-19 17:18:00 | 2021-02-19 21:14:00
BRK/REN/0032/10002 | 2021-02-19 17:20:00 | ‭0032‬ | RENTAL DIVISION | TH-2022 | TR-384 | ‭36620‬ |  | Workshop Repair Order |  | TYRES | CHECK AND CHANGE TYRES | 2021-02-19 17:18:00 | 2021-02-19 21:14:00
BRK/REN/0032/10003 | 2021-02-19 17:27:00 | ‭0032‬ | RENTAL DIVISION | TH-1954 | TR-529 | ‭36535‬ |  | Workshop Repair Order |  | [NAME] | WASHING AND GREASING | 2021-02-19 17:26:00 | 2021-02-19 21:14:00
BRK/REN/0032/10003 | 2021-02-19 17:27:00 | ‭0032‬ | RENTAL DIVISION | TH-1954 | TR-529 | ‭36535‬ |  | Workshop Repair Order |  | TYRES | ALL TYRES AIR PRESSURE TO BE CHECK | 2021-02-19 17:26:00 | 2021-02-19 21:14:00
BRK/REN/0032/10004 | 2021-02-19 18:17:00 | ‭0032‬ | RENTAL DIVISION | TH-2032 | TR-378 | ‭26524‬ |  | Workshop Repair Order |  | [NAME] | GENERAL CHECK UP | 2021-02-19 18:10:00 | 2021-02-19 23:19:00
BRK/REN/0032/10004 | 2021-02-19 18:17:00 | ‭0032‬ | RENTAL DIVISION | TH-2032 | TR-378 | ‭26524‬ |  | Workshop Repair Order |  | [NAME] | WASHING AND GREASING | 2021-02-19 18:10:00 | 2021-02-19 23:19:00
BRK/REN/0032/10004 | 2021-02-19 18:17:00 | ‭0032‬ | RENTAL DIVISION | TH-2032 | TR-378 | ‭26524‬ |  | Workshop Repair Order |  | TYRES | ALL TYRES AIR PRESSURE TO BE CHECK | 2021-02-19 18:10:00 | 2021-02-19 23:19:00
BRK/REN/0032/10005 | 2021-02-19 18:41:00 | ‭0032‬ | RENTAL DIVISION | TH-1998 | TR-221 | ‭29254‬ |  | Workshop Repair Order |  | TYRES | CHECK AND CHANGE TYRES | 2021-02-19 18:25:00 | 2021-02-19 21:14:00
BRK/REN/0032/10005 | 2021-02-19 18:41:00 | ‭0032‬ | RENTAL DIVISION | TH-1998 | TR-221 | ‭29254‬ |  | Workshop Repair Order |  | TYRES | TYRE PUNCTURE ( POSITION) | 2021-02-19 18:25:00 | 2021-02-19 21:14:00
BRK/REN/0032/10006 | 2021-02-19 18:45:00 | ‭0032‬ | RENTAL DIVISION | TH-2000 | TR-314 | ‭36554‬ |  | Workshop Repair Order |  | STEERING | VEHICLE PULLING RIGHT | 2021-02-19 18:40:00 | 2021-02-19 21:44:00
BRK/REN/0032/10006 | 2021-02-19 18:45:00 | ‭0032‬ | RENTAL DIVISION | TH-2000 | TR-314 | ‭36554‬ |  | Workshop Repair Order |  | TRAILER | TAIL DOOR SPONGE TO BE FIXED | 2021-02-19 18:40:00 | 2021-02-19 21:44:00