Spreadsheet: 849542d1699976261-use-email-address-as-the-unique-identifier-to-merge-records-sample-workbook-mep
Sheet: Sheet3

Customer ID | Display Name | Product Type | Period Start Date | Period End Date | [NAME] | Vendor Number | [NAME] | Quantity | FirstName | LastName | State | Degree | Complete Date | Language
2397380 | Customer 1 | Product A | 2023-11-07 10:13:20 | 2026-12-01 11:53:38 | [EMAIL] | 3 | Company 3 | 1 | Customer 1 First | Customer 1 First | FL | Renewal | 2026-12-01 11:53:38 | Spanish
2895208 | Customer 2 | Product A | 2023-11-07 10:11:14 | 2026-11-07 04:31:41 | [EMAIL] | 4 | Company 4 | 1 | Customer 2 First | Customer 2 First | VA | Initial | 2026-11-07 04:31:41 | Spanish
2454853 | Customer 3 | Product A | 2023-11-07 10:10:12 | 2026-11-29 00:00:00 | [EMAIL] | 4 | Company 4 | 1 | Customer 3 First | Customer 3 First | AR | Renewal | 2026-11-29 00:00:00 | Spanish
2904938 | Customer 4 | Product A | 2023-11-07 10:02:23 | 2027-02-11 04:32:26 | [EMAIL] | 5 | Company 5 | 1 | Customer 4 First | Customer 4 First | MD | Initial | 2027-02-11 04:32:26 | Spanish
2747145 | Customer 5 | Product A | 2023-11-07 09:59:08 | 2026-11-20 12:29:26 | [EMAIL] | 5 | Company 5 | 1 | Customer 5 First | Customer 5 First | CA | Renewal | 2026-11-20 12:29:26 | Spanish
2442989 | Customer 6 | Product B | 2023-11-07 09:55:30 | 2027-03-05 00:00:00 | [EMAIL] | 1 | Company 1 | 1 | Customer 6 First | Customer 6 First | FL | Initial | 2027-03-05 00:00:00 | English
2499123 | Customer 7 | Product C | 2023-11-07 09:47:37 | 2026-12-01 00:00:00 | [EMAIL] | 1 | Company 1 | 1 | Customer 7 First | Customer 7 First | VA | Renewal | 2026-12-01 00:00:00 | English
2458372 | Customer 8 | Product C | 2023-11-07 09:46:43 | 2026-12-13 00:00:00 | [EMAIL] | 2 | Company 2 | 1 | Customer 8 First | Customer 8 First | AR | Initial | 2026-12-13 00:00:00 | English
2393642 | Customer 9 | Product B | 2023-11-07 09:46:42 | 2027-01-04 09:18:38 | [EMAIL] | 2 | Company 2 | 1 | Customer 9 First | Customer 9 First | MD | Renewal | 2027-01-04 09:18:38 | English
2468490 | Customer 10 | Product A | 2023-11-07 09:45:12 | 2026-11-17 10:29:09 | [EMAIL] | 3 | Company 3 | 1 | Customer 10 First | Customer 10 First | CA | Initial | 2026-11-17 10:29:09 | English
Customer ID | Display Name | Product Type | Period Start Date | Period End Date | [NAME] | Vendor Number | [NAME] | Quantity | FirstName | LastName | State | Degree | Complete Date | Language
2397380 | Customer 1 | Product A | 2023-11-07 00:00:00 | 2026-12-01 00:00:00 | [EMAIL] | 3 | Company 3 | 1 | Customer 1 First | Customer 1 First | FL | Renewal | 2026-12-01 00:00:00 | Spanish
2442989 | Customer 6 | Product B | 2023-11-07 00:00:00 | 2027-03-05 00:00:00 | [EMAIL] | 1 | Company 1 | 1 | Customer 6 First | Customer 6 First | FL | Initial | 2027-03-05 00:00:00 | English
2895208 | Customer 2 | Product A | 2023-11-07 00:00:00 | 2026-11-07 00:00:00 | [EMAIL] | 4 | Company 4 | 1 | Customer 2 First | Customer 2 First | VA | Initial | 2026-11-07 00:00:00 | Spanish
2499123 | Customer 7 | Product C | 2023-11-07 00:00:00 | 2026-12-01 00:00:00 | [EMAIL] | 1 | Company 1 | 1 | Customer 7 First | Customer 7 First | VA | Renewal | 2026-12-01 00:00:00 | English
2454853 | Customer 3 | Product A | 2023-11-07 00:00:00 | 2026-11-29 00:00:00 | [EMAIL] | 4 | Company 4 | 1 | Customer 3 First | Customer 3 First | AR | Renewal | 2026-11-29 00:00:00 | Spanish
2458372 | Customer 8 | Product C | 2023-11-07 00:00:00 | 2026-12-13 00:00:00 | [EMAIL] | 2 | Company 2 | 1 | Customer 8 First | Customer 8 First | AR | Initial | 2026-12-13 00:00:00 | English
2904938 | Customer 4 | Product A | 2023-11-07 00:00:00 | 2027-02-11 00:00:00 | [EMAIL] | 5 | Company 5 | 1 | Customer 4 First | Customer 4 First | MD | Initial | 2027-02-11 00:00:00 | Spanish
2393642 | Customer 9 | Product B | 2023-11-07 00:00:00 | 2027-01-04 00:00:00 | [EMAIL] | 2 | Company 2 | 1 | Customer 9 First | Customer 9 First | MD | Renewal | 2027-01-04 00:00:00 | English
2747145 | Customer 5 | Product A | 2023-11-07 00:00:00 | 2026-11-20 00:00:00 | [EMAIL] | 5 | Company 5 | 1 | Customer 5 First | Customer 5 First | CA | Renewal | 2026-11-20 00:00:00 | Spanish
2468490 | Customer 10 | Product A | 2023-11-07 00:00:00 | 2026-11-17 00:00:00 | [EMAIL] | 3 | Company 3 | 1 | Customer 10 First | Customer 10 First | CA | Initial | 2026-11-17 00:00:00 | English