Spreadsheet: 789973d1659459465-help-with-extracting-info-in-a-single-cell-and-outputting-in-a-different-format-book3
Sheet: Sheet1

[NAME], Alloy Wheels, Change of Registration, CO2 Emissions - 107 g/km, Condition Declaration - EXHAUST BLOWING, DVSA Mileage - 24k, [NAME]) - 2, Last Srvc - 06/21 15k, [NAME], [NAME]), [NAME], S Inf - 2 services, Vehicle Location - Walsall
[NAME], Alloy Wheels, CO2 Emissions - 113 g/km, DVSA Mileage - 25k, [NAME]) - 2, Last Srvc - 07/22 25k, [NAME], Navigation Media - sd in office, Navigation System, NOx Emissions - 0.053 g/km, [NAME]), [NAME], S Inf - 2 services, Vehicle Location - Derby
17" Alloy Wheels, Cherished Plate - not guaranteed, Climate Control, CO2 Emissions - 135 g/km, [NAME], [NAME]) - 2, Last Srvc - 07/21 11k, Navigation System, [NAME]), [NAME], Vehicle Location - Manchester
[NAME], Alloy Wheels, CO2 Emissions - 116 g/km, DVSA Mileage - 11k 12k 15k 20k 24k 27k, DVSA Mileage - 30k 33k, [NAME]) - 2, Last Srvc - 04/22 33k, [NAME], NOx Emissions - 0.027 g/km, [NAME]), [NAME] srvc 1 main dlr, V5C/2 Only, Vehicle Location - Blackbushe
[NAME], Alloy Wheels, CO2 Emissions - 106 g/km, DVSA Mileage - 18k 26k 28k, [NAME]) - 1, Last Srvc - 12/20 26k, [NAME], [NAME]), S Inf - 3 services, Vehicle Location - Manchester
19" Alloy Wheels, Climate Control, CO2 Emissions - 164 g/km, [NAME]) - 2, Last Srvc - 02/21 5k, Navigation System, [NAME]), [NAME], S Inf - 1 service, Vehicle Location - Manchester
Alloy Wheels, Climate Control, CO2 Emissions - 102 g/km, DVSA Mileage - 22k 30k 35k 40k 42k 44k, [NAME]) - 1, Last Srvc - 07/21 44k, [NAME], [NAME]), S Inf - 8 services, Vehicle Location - Livingston
[NAME], Alloy Wheels, CO2 Emissions - 120 g/km, DVSA Mileage - 5k 6k 7k, [NAME]) - 2, Last Srvc - 07/22 8k, [NAME], Navigation System, NOx Emissions - 0.034 g/km, [NAME]), [NAME] srvc, Vehicle Location - Kingsnorth
SAMPLE DATA 1
[NAME], Alloy Wheels, Change of Registration, CO2 Emissions - 107 g/km, Condition Declaration - EXHAUST BLOWING, DVSA Mileage - 24k, [NAME]) - 2, Last Srvc - 06/21 15k, [NAME], [NAME]), [NAME], S Inf - 2 services, Vehicle Location - Walsall | 2 services, 06/21 15k,
[NAME], Alloy Wheels, CO2 Emissions - 113 g/km, DVSA Mileage - 25k, [NAME]) - 2, Last Srvc - 07/22 25k, [NAME], Navigation Media - sd in office, Navigation System, NOx Emissions - 0.053 g/km, [NAME]), [NAME], S Inf - 2 services, Vehicle Location - Derby | 2 services, 07/22 25k,
17" Alloy Wheels, Cherished Plate - not guaranteed, Climate Control, CO2 Emissions - 135 g/km, [NAME], [NAME]) - 2, Last Srvc - 07/21 11k, Navigation System, [NAME]), [NAME], Vehicle Location - Manchester | 1 srvc, 07/21 11k, 17" Alloy Wheels
[NAME], Alloy Wheels, CO2 Emissions - 116 g/km, DVSA Mileage - 11k 12k 15k 20k 24k 27k, DVSA Mileage - 30k 33k, [NAME]) - 2, Last Srvc - 04/22 33k, [NAME], NOx Emissions - 0.027 g/km, [NAME]), [NAME] srvc 1 main dlr, V5C/2 Only, Vehicle Location - Blackbushe | 8 srvc 1 main dlr, 04/22 33k
[NAME], Alloy Wheels, CO2 Emissions - 106 g/km, DVSA Mileage - 18k 26k 28k, [NAME]) - 1, Last Srvc - 12/20 26k, [NAME], [NAME]), S Inf - 3 services, Vehicle Location - Manchester | 3 services, 12/20 26k
19" Alloy Wheels, Climate Control, CO2 Emissions - 164 g/km, [NAME]) - 2, Last Srvc - 02/21 5k, Navigation System, [NAME]), [NAME], S Inf - 1 service, Vehicle Location - Manchester | 1 service, 02/21 5k, 19" Alloy wheels
Alloy Wheels, Climate Control, CO2 Emissions - 102 g/km, DVSA Mileage - 22k 30k 35k 40k 42k 44k, [NAME]) - 1, Last Srvc - 07/21 44k, [NAME], [NAME]), S Inf - 8 services, Vehicle Location - Livingston | 8 services, 07/21 44k
[NAME], Alloy Wheels, CO2 Emissions - 120 g/km, DVSA Mileage - 5k 6k 7k, [NAME]) - 2, Last Srvc - 07/22 8k, [NAME], Navigation System, NOx Emissions - 0.034 g/km, [NAME]), [NAME] srvc, Vehicle Location - Kingsnorth | 2 srvc, 07/22 8k
SAMPLE DATA 2
19" Alloy Wheels, Change of Registration, Climate Control, CO2 Emissions - 121 g/km, DVSA Mileage - 35k, [NAME]) - 2, Last Srvc - 01/22 38k main dlr, [NAME], [NAME], Navigation SD Card, NOx Emissions - 0.038 g/km, [NAME]), [NAME], [NAME] srvc 3 main dlr, Vehicle Location - Blackbushe | srvc prt 3 srvc 3 main dlr,  01/22 38k, 19" Alloy Wheels
18" Alloy Wheels, Climate Control, CO2 Emissions - 40 g/km, Cruise Control, DVSA Mileage - 26k 34k, [NAME], Folding Door Mirrors, Heated Door Mirror(s), Heated Front Seats, [NAME]) - 2, Last Srvc - 04/21 26k, [NAME], Navigation System, NOx Emissions - 0.005 g/km, [NAME]), [NAME], [NAME] srvc 3 main dlr, Stereo - DAB, Vehicle Charge Cable(s) - 2 present, Vehicle Location - Bristol - West Dock | srvc prt 3 srvc 3 main dlr, 04/21 26k, 18" Alloy Wheels
Alloy Wheels, CO2 Emissions - 109 g/km, DVSA Mileage - 25k 29k, [NAME]) - 2, Last Srvc - 11/21 29k, Maint Prt - 2 srvc 1 main dlr, [NAME], Navigation SD Card, Navigation System, [NAME]), Vehicle Location - Blackbushe | 2 srvc 1 main dlr, Last Srvc - 11/21 29k
18" Alloy Wheels, Climate Control, CO2 Emissions - 40 g/km, DVSA Mileage - 32k, [NAME]) - 2, Last Srvc - 07/21 31k, [NAME], [NAME]), [NAME], S Inf - 3 services, Vehicle Charge Cable(s) - 1 present, Vehicle Location - Thurleigh | 3 services, 7/21 31k, 18" Alloy Wheels
17" Alloy Wheels, Climate Control, CO2 Emissions - 38 g/km, DVSA Mileage - 29k 40k, [NAME]) - 2, Last Srvc - 04/22 38k, [NAME], Navigation System - SD card in office, [NAME] g/km, [NAME]), S Inf - 4 services, Vehicle Location - Bedford | 4 services,  04/22 38k, 17" Alloy Wheels
Alloy Wheels, Climate Control, CO2 Emissions - 116 g/km, DVSA Mileage - 30k, [NAME]) - 2, Last Srvc - 04/22 32k, [NAME], Navigation System, NOx Emissions - 0.031 g/km, [NAME]), S Inf - 13 22 32, [NAME] srvc 3 main dlr, Vehicle Location - Bridgwater | 3 srvc 3 main dlr, 04/22 32k,