Concatenating data depending on duplicate emails and names

Hey!

I've been working on a project to help shorten the time it takes to filter and sort out some contacts from a spreadsheet to upload as a CSV. Only thing is I have run into a roadblock with a specific part of the sorting process which is compressing contact information of contacts with different names but using the same email.
I have attached an example of what I mean, but in words, the contact list is to send to a list of contacts that have family members in a retirement village. there could be multiple contacts for one person or multiple people for one contact.

I'm wanting to detect the duplicates by email and then it will concatenate any first or preferred names and then can just delete the rest. The first row of double data would be the one that would stay.

I already have a macro workbook with a heap of VBA in it doing other things so having this solution in VBA will help a heap. Don't worry about Dim names and stuff, I can go through and adjust to suit what I have on the other workbook (just not sharing it as its confidential information)
This needs to be Mac friendly.

Let me know if I need to explain more.

This is only for the data layouts that you uploaded.

Please Login or Register  to view this content.

Thanks for the speedy reply!
I have gone through the code but am struggling to understand how it's working... I do have more columns in the actual file but thought if I got a rough idea of what you sent I can just implement it into my workbook.
Unfortunately, I am still fresh in VBA and am still learning all the functions and stuff.
Would you be able to explain how it all works? For more of an idea cause I think I forgot to explain it in the initial thread, I will have filtered to show all duplicate email rows. and there are a couple hundred. there is other data in that but It is data that i didn't add that might need to be in it but all it is, is different letter terms that I could also concat.

1) Is it working with your wokbook uploaded?

2) As I already mentioned, I coded based on your data layout.
If it is not like that, you shoukd uplaod the file with identical data layouts as your true file.

Anyway, I am not with my pc, so my next post will be late.

No worries, Sorry about that I have attached an updated version with identical headers and data examples to my main document.
I've also added one more scenario, where one person is in type 1 and the other is in type 2. (There will only ever be two types)

If possible could you also explain a few of the functions? just so I can understand it better.

The code is assuming the data is sorted by email column.

Please Login or Register  to view this content.

Thanks! I'll let you know how it goes