Create a unique identifier for records that contain matching fields

[CSpicer1202]

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

[CSpicer1202]

resolved