Spreadsheet: 812914d1673450227-need-help-with-merging-more-than-one-row-of-data-testdata
Sheet: MailMerge

Test | Membership Code | Name | Address | End Date | Active | [NAME] | Phone | Car 1 Registration | TestData.Registration | TestData.[NAME] | TestData.Departure Date | TestData.[NAME] | TestData.Departure Time | TestData.Total Time
 | 2145458 | [NAME] | 92, [NAME] | 2023-03-09 00:00:00 | True | [EMAIL] | 99451264 | ABZ 205 | ABZ 205 | 2022-03-02 00:00:00 | 2022-03-02 00:00:00 | 11:45:00 | 15:56:00 | 04:11:00
 | 2145458 | [NAME] | 92, [NAME] | 2023-03-09 00:00:00 | True | [EMAIL] | 99451264 | ABZ 205 | ABZ 205 | 2022-07-28 00:00:00 | 2022-07-28 00:00:00 | 08:12:00 | 19:00:00 | 10:48:00
 | 2145458 | [NAME] | 92, [NAME] | 2023-03-09 00:00:00 | True | [EMAIL] | 99451264 | ABZ 205 | ABZ 205 | 2022-08-19 00:00:00 | 2022-08-19 00:00:00 | 09:00:00 | 20:30:00 | 11:30:00
 | 1125547 | [NAME] | 45, [NAME] FGR 2131 | 2023-06-13 00:00:00 | True | [EMAIL] | 77145125 | ACD 097 | ACD 097 | 2022-01-25 00:00:00 | 2022-01-25 00:00:00 | 10:23:00 | 16:05:00 | 05:42:00
 | 1125547 | [NAME] | 45, [NAME] FGR 2131 | 2023-06-13 00:00:00 | True | [EMAIL] | 77145125 | ACD 097 | ACD 097 | 2022-02-05 00:00:00 | 2022-02-05 00:00:00 | 17:00:00 | 20:30:00 | 03:30:00
 | 1125547 | [NAME] | 45, [NAME] FGR 2131 | 2023-06-13 00:00:00 | True | [EMAIL] | 77145125 | ACD 097 | ACD 097 | 2022-05-20 00:00:00 | 2022-05-20 00:00:00 | 16:45:00 | 19:00:00 | 02:15:00
 | 1125547 | [NAME] | 45, [NAME] FGR 2131 | 2023-06-13 00:00:00 | True | [EMAIL] | 77145125 | ACD 097 | ACD 097 | 2022-10-23 00:00:00 | 2022-10-23 00:00:00 | 09:00:00 | 20:30:00 | 11:30:00
 | 1125478 | [NAME] | 8, [NAME] | 2022-05-09 00:00:00 | False | [EMAIL] | 79782115 | ACD 245 | ACD 245 | 2022-06-12 00:00:00 | 2022-06-12 00:00:00 | 07:45:00 | 16:55:00 | 09:10:00
 | 1125478 | [NAME] | 8, [NAME] | 2022-05-09 00:00:00 | False | [EMAIL] | 79782115 | ACD 245 | ACD 245 | 2022-11-06 00:00:00 | 2022-11-06 00:00:00 | 10:32:00 | 15:21:00 | 04:49:00
 | 6547941 | [NAME] | 47, [NAME] Ubbaldeska Paola PLA 1116 | 2023-06-10 00:00:00 | True | [EMAIL] | 79511452 | BBM 332 | BBM 332 | 2022-06-18 00:00:00 | 2022-06-18 00:00:00 | 09:04:00 | 14:36:00 | 05:32:00
 | 6547941 | [NAME] | 47, [NAME] Ubbaldeska Paola PLA 1116 | 2023-06-10 00:00:00 | True | [EMAIL] | 79511452 | BBM 332 | BBM 332 | 2022-11-15 00:00:00 | 2022-11-15 00:00:00 | 11:42:00 | 17:51:00 | 06:09:00
 | 6547812 | [NAME] | 64, [NAME] ZTN 3000 | 2022-03-19 00:00:00 | False | [EMAIL] | 79145115 | [NAME] 235 | [NAME] 235 | 2022-01-25 00:00:00 | 2022-01-25 00:00:00 | 11:45:00 | 15:56:00 | 04:11:00
 | 6547812 | [NAME] | 64, [NAME] ZTN 3000 | 2022-03-19 00:00:00 | False | [EMAIL] | 79145115 | [NAME] 235 | [NAME] 235 | 2022-04-15 00:00:00 | 2022-04-15 00:00:00 | 10:23:00 | 16:05:00 | 05:42:00
 | 6547812 | [NAME] | 64, [NAME] ZTN 3000 | 2022-03-19 00:00:00 | False | [EMAIL] | 79145115 | [NAME] 235 | [NAME] 235 | 2022-08-25 00:00:00 | 2022-08-25 00:00:00 | 16:45:00 | 19:00:00 | 02:15:00
 | 6547812 | [NAME] | 64, [NAME] ZTN 3000 | 2022-03-19 00:00:00 | False | [EMAIL] | 79145115 | [NAME] 235 | [NAME] 235 | 2022-11-20 00:00:00 | 2022-11-20 00:00:00 | 09:36:00 | 18:27:00 | 08:51:00
 | 7896542 | Ruby Hayes | [NAME], [NAME] Hal Lija LJA 9012 | 2023-10-26 00:00:00 | True | [EMAIL] | 99587458 | LOA 904 | LOA 904 | 2022-01-25 00:00:00 | 2022-01-25 00:00:00 | 09:20:00 | 12:00:00 | 02:40:00
 | 7896542 | Ruby Hayes | [NAME], [NAME] Hal Lija LJA 9012 | 2023-10-26 00:00:00 | True | [EMAIL] | 99587458 | LOA 904 | LOA 904 | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | 07:30:00 | 17:00:00 | 09:30:00
 | 7896542 | Ruby Hayes | [NAME], [NAME] Hal Lija LJA 9012 | 2023-10-26 00:00:00 | True | [EMAIL] | 99587458 | LOA 904 | LOA 904 | 2022-07-05 00:00:00 | 2022-07-05 00:00:00 | 10:23:00 | 16:05:00 | 05:42:00
 | 7896542 | Ruby Hayes | [NAME], [NAME] Hal Lija LJA 9012 | 2023-10-26 00:00:00 | True | [EMAIL] | 99587458 | LOA 904 | LOA 904 | 2022-11-02 00:00:00 | 2022-11-02 00:00:00 | 16:45:00 | 19:00:00 | 02:15:00
 | 4547895 | [NAME] | 27, [NAME] FGR 2131 | 2023-02-06 00:00:00 | True | [EMAIL] | 79547874 | LSP 467 | LSP 467 | 2022-02-10 00:00:00 | 2022-02-10 00:00:00 | 09:00:00 | 20:30:00 | 11:30:00
 | 4547895 | [NAME] | 27, [NAME] FGR 2131 | 2023-02-06 00:00:00 | True | [EMAIL] | 79547874 | LSP 467 | LSP 467 | 2022-02-27 00:00:00 | 2022-02-27 00:00:00 | 07:30:00 | 17:00:00 | 09:30:00
 | 4547895 | [NAME] | 27, [NAME] FGR 2131 | 2023-02-06 00:00:00 | True | [EMAIL] | 79547874 | LSP 467 | LSP 467 | 2022-05-03 00:00:00 | 2022-05-03 00:00:00 | 09:00:00 | 20:30:00 | 11:30:00
 | 4547895 | [NAME] | 27, [NAME] FGR 2131 | 2023-02-06 00:00:00 | True | [EMAIL] | 79547874 | LSP 467 | LSP 467 | 2022-12-28 00:00:00 | 2022-12-28 00:00:00 | 11:42:00 | 17:51:00 | 06:09:00
 | 3652147 | [NAME] | 12, [NAME] | 2023-11-11 00:00:00 | True | [EMAIL] | 99458741 | SAD 235 | SAD 235 | 2022-03-01 00:00:00 | 2022-03-01 00:00:00 | 09:04:00 | 14:36:00 | 05:32:00
 | 3652147 | [NAME] | 12, [NAME] | 2023-11-11 00:00:00 | True | [EMAIL] | 99458741 | SAD 235 | SAD 235 | 2022-04-30 00:00:00 | 2022-04-30 00:00:00 | 08:12:00 | 19:00:00 | 10:48:00
 | 3652147 | [NAME] | 12, [NAME] | 2023-11-11 00:00:00 | True | [EMAIL] | 99458741 | SAD 235 | SAD 235 | 2022-09-25 00:00:00 | 2022-09-25 00:00:00 | 11:42:00 | 17:51:00 | 06:09:00
 | 3652147 | [NAME] | 12, [NAME] | 2023-11-11 00:00:00 | True | [EMAIL] | 99458741 | SAD 235 | SAD 235 | 2022-12-12 00:00:00 | 2022-12-12 00:00:00 | 17:00:00 | 20:30:00 | 03:30:00
 | 6695412 | [NAME] | 22, Vjal De Paule Hal Balzan BZN 9023 | 2022-07-22 00:00:00 | False | [EMAIL] | 99654782 | SCG 256 | SCG 256 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00 | 08:32:00 | 17:00:00 | 08:28:00
 | 6695412 | [NAME] | 22, Vjal De Paule Hal Balzan BZN 9023 | 2022-07-22 00:00:00 | False | [EMAIL] | 99654782 | SCG 256 | SCG 256 | 2022-07-14 00:00:00 | 2022-07-14 00:00:00 | 09:20:00 | 12:00:00 | 02:40:00
 | 6695412 | [NAME] | 22, Vjal De Paule Hal Balzan BZN 9023 | 2022-07-22 00:00:00 | False | [EMAIL] | 99654782 | SCG 256 | SCG 256 | 2022-09-28 00:00:00 | 2022-09-28 00:00:00 | 09:36:00 | 18:27:00 | 08:51:00
 | 6695412 | [NAME] | 22, Vjal De Paule Hal Balzan BZN 9023 | 2022-07-22 00:00:00 | False | [EMAIL] | 99654782 | SCG 256 | SCG 256 | 2022-12-18 00:00:00 | 2022-12-18 00:00:00 | 16:45:00 | 19:00:00 | 02:15:00
 | 1247854 | [NAME] | 20, [NAME] [NAME] 1420 | 2023-11-24 00:00:00 | True | jackbugeja![EMAIL] | 77145215 | SPD 342 | SPD 342 | 2022-04-23 00:00:00 | 2022-04-23 00:00:00 | 09:20:00 | 12:00:00 | 02:40:00
 | 1247854 | [NAME] | 20, [NAME] [NAME] 1420 | 2023-11-24 00:00:00 | True | jackbugeja![EMAIL] | 77145215 | SPD 342 | SPD 342 | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 | 10:32:00 | 15:21:00 | 04:49:00
 | 1247854 | [NAME] | 20, [NAME] [NAME] 1420 | 2023-11-24 00:00:00 | True | jackbugeja![EMAIL] | 77145215 | SPD 342 | SPD 342 | 2022-11-24 00:00:00 | 2022-11-24 00:00:00 | 08:32:00 | 17:00:00 | 08:28:00