Hi
I'm using a waterfall approach to group these entries together (by email address, phone number, address). Although row 1 and 3 do not match, i want them to group together as i can see they match from the further information in row 4 and row 5. I Would like the final output to be a new group ID for this specific person.
| ID | First Name | Last Name | Email Address | Phone Number | Address | Group IDs |
| 1 | Joe | Bloggs | JoeBloggs@hotmail.com | | 1 Road | 1,1,1 |
| 2 | Joe | Bloggs | JoeBloggs@hotmail.com | | | 1,2,2 |
| 3 | Joe | Bloggs | Joe.Bloggs@gmail.com | | | 3,3,3 |
| 4 | Joe | Bloggs | Joe.Bloggs@gmail.com | 1234567 | | 3,4,4 |
| 5 | Joe | Bloggs | JoeBloggs@hotmail.com | 1234567 | 1 Road | 1,4,1 |
