Spreadsheet: 62818d1263830707-hide-rows-depending-on-data-but-merge-other-data-test-2-
Sheet: Sheet1

ID | Name | License | Car | Job | Start Date | End Date | Comments
43986 | Mr Cox | LB56PNN | PEUGEOT 107 | MOT TEST | 2010-02-03 00:00:00 | 2010-02-07 00:00:00
43986 | Mr Cox | LB56PNN | PEUGEOT 107 | CARRY OUT 30.000 SERVICE | 2010-02-03 00:00:00 | 2010-02-07 00:00:00
43986 | Mr Cox | LB56PNN | PEUGEOT 107 | CUSTOMER WAITING 9.30AM | 2010-02-03 00:00:00 | 2010-02-07 00:00:00
43986 | Mr Cox | LB56PNN | PEUGEOT 107 | Oil top up - Mobil 10W40. | 2010-02-03 00:00:00 | 2010-02-07 00:00:00
44260 | [NAME] | GY59ULN | 207 SW SPT HDI 90 | [NAME] Peugeot First Servic | 2010-12-19 00:00:00 | 2012-12-19 00:00:00
44260 | [NAME] | GY59ULN | 207 SW SPT HDI 90 | CUSTOMER WAITING 3.00PM | 2010-12-19 00:00:00 | 2012-12-19 00:00:00
44563 | Mr I Aitken | GP54PYA | Peugeot 407 5Dr SW 2.0 HDi 136 | MOT TEST | 2010-04-29 00:00:00 | 2010-02-15 00:00:00 | CAMBELT REQD B4 MOT!!
44563 | Mr I Aitken | GP54PYA | Peugeot 407 5Dr SW 2.0 HDi 136 | [NAME] | 2010-04-29 00:00:00 | 2010-02-15 00:00:00 | CAMBELT REQD B4 MOT!!
44595 | Mrs J [NAME] | HK55ZNT | 206 | MOT TEST | 2009-02-04 00:00:00 | 2010-01-31 00:00:00
44595 | Mrs J [NAME] | HK55ZNT | 206 | Carry out level 3 'P' Service | 2009-02-04 00:00:00 | 2010-01-31 00:00:00
44595 | Mrs J [NAME] | HK55ZNT | 206 | COLLECTION AND DELIVERY | 2009-02-04 00:00:00 | 2010-01-31 00:00:00
44595 | Mrs J [NAME] | HK55ZNT | 206 | Oil top up - Mobil 10W40. | 2009-02-04 00:00:00 | 2010-01-31 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | INVESTIGATE VERY STICKY CHANGI | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | CUSTOMER WAITING 10.00AM | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | Oil top up - Mobil 10W40. | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | ADVISE *********************** | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | Hire car at reduced rate | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | Hire car at reduced rate | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | Hire car at reduced rate | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44631 | [NAME] | KW07DZC | Peugeot 307S 1.6 16V Tiptronic | Notes - Old job card m | 2010-06-15 00:00:00 | 2010-06-15 00:00:00
44754 | [NAME] | GX05CWJ | PEUGEOT 307 | Investigate rear bulb out. | 2008-04-09 00:00:00 | 2008-07-22 00:00:00
44754 | [NAME] | GX05CWJ | PEUGEOT 307 | Investigate washers don't work | 2008-04-09 00:00:00 | 2008-07-22 00:00:00
44754 | [NAME] | GX05CWJ | PEUGEOT 307 | CUSTOMER WAITING 3:30 | 2008-04-09 00:00:00 | 2008-07-22 00:00:00
44762 | Mrs J King | [NAME] | Peugeot 206 LX 1.4 5 Dr | MOT TEST | 2008-12-27 00:00:00 | 2009-01-08 00:00:00
44762 | Mrs J King | [NAME] | Peugeot 206 LX 1.4 5 Dr | Carry out level 1 'P' Service | 2008-12-27 00:00:00 | 2009-01-08 00:00:00
44762 | Mrs J King | [NAME] | Peugeot 206 LX 1.4 5 Dr | COLLECTION AND DELIVERY FROM H | 2008-12-27 00:00:00 | 2009-01-08 00:00:00
44762 | Mrs J King | [NAME] | Peugeot 206 LX 1.4 5 Dr | Oil top up - Mobil 10W40. | 2008-12-27 00:00:00 | 2009-01-08 00:00:00
44800 | Mr [NAME] | CK52NDD | Peugeot 307 S Estate | REPLACE WORN ALTERNATOR BELT | 2010-10-01 00:00:00 | 2011-01-12 00:00:00
44800 | Mr [NAME] | CK52NDD | Peugeot 307 S Estate | CUSTOMER WAITING 09.00AM | 2010-10-01 00:00:00 | 2011-01-12 00:00:00
44814 | Mr K Bull | GU08HBL | 207 5Dr HAT 1.4 75 M:play | INVESTIGATE INTERMITTANTLY WHE | 2010-03-12 00:00:00 | 2011-03-01 00:00:00
44814 | Mr K Bull | GU08HBL | 207 5Dr HAT 1.4 75 M:play | ADVISE CAR MAY BE DROPPED OFF | 2010-03-12 00:00:00 | 2011-03-01 00:00:00
44832 | Mr [NAME] | D16WRH | Peugeot 106 QS | MOT TEST AT REDUCED RATE | 2010-02-01 00:00:00 | 2010-02-01 00:00:00
44832 | Mr [NAME] | D16WRH | Peugeot 106 QS | OSR TYRE ROTAION INCORRECT, | 2010-02-01 00:00:00 | 2010-02-01 00:00:00
44832 | Mr [NAME] | D16WRH | Peugeot 106 QS | CUSTOMER WAITING 3.00 | 2010-02-01 00:00:00 | 2010-02-01 00:00:00
44835 | Esp Ltd | GU58LHD | [NAME] 120VAN 1000KG | CARRY OUT NEXT SERVICE | 2009-09-04 00:00:00 | 2011-09-01 00:00:00 | CALL FOR O/NUMBER
44835 | Esp Ltd | GU58LHD | [NAME] 120VAN 1000KG | CARRY OUT 20,000 SERVICE 219.9 | 2009-09-04 00:00:00 | 2011-09-01 00:00:00 | CALL FOR O/NUMBER
44871 | Mrs N Morris | GP06UNB | 107 Urban Semi-Auto | Carry out level 3 'P' Service | 2010-01-15 00:00:00 | 2010-06-10 00:00:00
44871 | Mrs N Morris | GP06UNB | 107 Urban Semi-Auto | COLLECTION AND DELIVERY | 2010-01-15 00:00:00 | 2010-06-10 00:00:00
44904 | [NAME] | GX54BYT | PEUGEOT 206 SW PETROL INPORT N | Carry out level 1 'P' Service | 2009-12-15 00:00:00 | 2010-09-15 00:00:00
44904 | [NAME] | GX54BYT | PEUGEOT 206 SW PETROL INPORT N | ADVISE *********************** | 2009-12-15 00:00:00 | 2010-09-15 00:00:00
44904 | [NAME] | GX54BYT | PEUGEOT 206 SW PETROL INPORT N | CUSTOMER WAITING 11:00 | 2009-12-15 00:00:00 | 2010-09-15 00:00:00
44904 | [NAME] | GX54BYT | PEUGEOT 206 SW PETROL INPORT N | Oil top up - Mobil 10W40. | 2009-12-15 00:00:00 | 2010-09-15 00:00:00
44915 | Mr A J [NAME] | GP57BMO | Peugeot 207 5Dr HAT 1.6 HDi 90 | CARRY OUT 12,000 MILE SERVICE | 2009-02-16 00:00:00 | 2011-02-16 00:00:00
44915 | Mr A J [NAME] | GP57BMO | Peugeot 207 5Dr HAT 1.6 HDi 90 | CUSTOMER WAITING 11.30AM | 2009-02-16 00:00:00 | 2011-02-16 00:00:00
44927 | Mr R Smith | HK55UJF | Peugeot 407 2.0D | MOT TEST | 2010-09-30 00:00:00 | 2010-01-20 00:00:00
44927 | Mr R Smith | HK55UJF | Peugeot 407 2.0D | CUSTOMER WAITING 10.30AM | 2010-09-30 00:00:00 | 2010-01-20 00:00:00
44928 | Mr N Humphrey | GV53UJA | 206 Quicksilver | Investigate knocking noise fro | 2011-01-24 00:00:00 | 2011-01-24 00:00:00