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

Membership Code | Registration | [NAME] | Departure Date | [NAME] | Departure Time | Total Time | Payment Method
2145458 | ABZ 205 | 2022-03-02 00:00:00 | 2022-03-02 00:00:00 | 11:45:00 | 15:56:00 |  | Membership
2145458 | ABZ 205 | 2022-07-28 00:00:00 | 2022-07-28 00:00:00 | 08:12:00 | 19:00:00 |  | Membership
2145458 | ABZ 205 | 2022-08-19 00:00:00 | 2022-08-19 00:00:00 | 09:00:00 | 20:30:00 |  | Membership
1125547 | ACD 097 | 2022-01-25 00:00:00 | 2022-01-25 00:00:00 | 10:23:00 | 16:05:00 |  | Membership
1125547 | ACD 097 | 2022-02-05 00:00:00 | 2022-02-05 00:00:00 | 17:00:00 | 20:30:00 |  | Membership
1125547 | ACD 097 | 2022-05-20 00:00:00 | 2022-05-20 00:00:00 | 16:45:00 | 19:00:00 |  | Membership
1125547 | ACD 097 | 2022-06-19 00:00:00 | 2022-06-19 00:00:00 | 11:45:00 | 15:56:00 |  | Membership
1125547 | ACD 097 | 2022-10-23 00:00:00 | 2022-10-23 00:00:00 | 09:00:00 | 20:30:00 |  | Membership
1125478 | ACD 245 | 2022-06-12 00:00:00 | 2022-06-12 00:00:00 | 07:45:00 | 16:55:00 |  | Membership
1125478 | ACD 245 | 2022-11-06 00:00:00 | 2022-11-06 00:00:00 | 10:32:00 | 15:21:00 |  | Membership
 | ASD 654 | 2022-07-30 00:00:00 | 2022-07-30 00:00:00 | 08:32:00 | 17:00:00 |  | Credit Card
6547941 | BBM 332 | 2022-06-18 00:00:00 | 2022-06-18 00:00:00 | 09:04:00 | 14:36:00 |  | Membership
6547941 | BBM 332 | 2022-11-15 00:00:00 | 2022-11-15 00:00:00 | 11:42:00 | 17:51:00 |  | Membership
 | EWQ 124 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 17:00:00 | 20:30:00 |  | Credit Card
 | EWQ 124 | 2022-12-27 00:00:00 | 2022-12-27 00:00:00 | 10:32:00 | 15:21:00 |  | Credit Card
6547812 | [NAME] 235 | 2022-01-25 00:00:00 | 2022-01-25 00:00:00 | 11:45:00 | 15:56:00 |  | Membership
6547812 | [NAME] 235 | 2022-01-25 00:00:00 | 2022-01-25 00:00:00 | 08:12:00 | 19:00:00 |  | Membership
6547812 | [NAME] 235 | 2022-02-20 00:00:00 | 2022-02-20 00:00:00 | 16:45:00 | 19:00:00 |  | Membership
6547812 | [NAME] 235 | 2022-02-28 00:00:00 | 2022-02-28 00:00:00 | 07:45:00 | 16:55:00 |  | Membership
6547812 | [NAME] 235 | 2022-04-15 00:00:00 | 2022-04-15 00:00:00 | 10:23:00 | 16:05:00 |  | Membership
6547812 | [NAME] 235 | 2022-08-25 00:00:00 | 2022-08-25 00:00:00 | 16:45:00 | 19:00:00 |  | Membership
6547812 | [NAME] 235 | 2022-11-20 00:00:00 | 2022-11-20 00:00:00 | 09:36:00 | 18:27:00 |  | Membership
 | LKJ 023 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 08:32:00 | 17:00:00 |  | Credit Card
7896542 | LOA 904 | 2022-01-25 00:00:00 | 2022-01-25 00:00:00 | 09:20:00 | 12:00:00 |  | Membership
7896542 | LOA 904 | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | 07:30:00 | 17:00:00 |  | Membership
7896542 | LOA 904 | 2022-07-05 00:00:00 | 2022-07-05 00:00:00 | 10:23:00 | 16:05:00 |  | Membership
7896542 | LOA 904 | 2022-11-02 00:00:00 | 2022-11-02 00:00:00 | 16:45:00 | 19:00:00 |  | Membership
4547895 | LSP 467 | 2022-02-10 00:00:00 | 2022-02-10 00:00:00 | 09:00:00 | 20:30:00 |  | Membership
4547895 | LSP 467 | 2022-02-27 00:00:00 | 2022-02-27 00:00:00 | 07:30:00 | 17:00:00 |  | Membership
4547895 | LSP 467 | 2022-05-03 00:00:00 | 2022-05-03 00:00:00 | 09:00:00 | 20:30:00 |  | Membership
4547895 | LSP 467 | 2022-08-15 00:00:00 | 2022-08-15 00:00:00 | 17:00:00 | 20:30:00 |  | Membership
4547895 | LSP 467 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 17:00:00 | 20:30:00 |  | Membership
4547895 | LSP 467 | 2022-12-28 00:00:00 | 2022-12-28 00:00:00 | 11:42:00 | 17:51:00 |  | Membership
 | QWE 145 | 2022-01-29 00:00:00 | 2022-01-29 00:00:00 | 08:32:00 | 17:00:00 |  | Credit Card
3652147 | SAD 235 | 2022-03-01 00:00:00 | 2022-03-01 00:00:00 | 09:04:00 | 14:36:00 |  | Membership
3652147 | SAD 235 | 2022-04-30 00:00:00 | 2022-04-30 00:00:00 | 08:12:00 | 19:00:00 |  | Membership
3652147 | SAD 235 | 2022-09-25 00:00:00 | 2022-09-25 00:00:00 | 11:42:00 | 17:51:00 |  | Membership
3652147 | SAD 235 | 2022-12-12 00:00:00 | 2022-12-12 00:00:00 | 17:00:00 | 20:30:00 |  | Membership
6695412 | SCG 256 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00 | 08:32:00 | 17:00:00 |  | Membership
6695412 | SCG 256 | 2022-07-14 00:00:00 | 2022-07-14 00:00:00 | 09:20:00 | 12:00:00 |  | Membership
6695412 | SCG 256 | 2022-09-28 00:00:00 | 2022-09-28 00:00:00 | 09:36:00 | 18:27:00 |  | Membership
6695412 | SCG 256 | 2022-12-18 00:00:00 | 2022-12-18 00:00:00 | 16:45:00 | 19:00:00 |  | Membership
1247854 | SPD 342 | 2022-04-23 00:00:00 | 2022-04-23 00:00:00 | 09:20:00 | 12:00:00 |  | Membership
1247854 | SPD 342 | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 | 10:32:00 | 15:21:00 |  | Membership
1247854 | SPD 342 | 2022-11-24 00:00:00 | 2022-11-24 00:00:00 | 08:32:00 | 17:00:00 |  | Membership
 |  |  |  |  |  |  | Membership