Complex Usage of Concatenate Formula

Hi,

My current CRM gives me our list of contacts in a complex way that poses a challenge when trying to import the data to any email marketing program.

I have attached 2 lists that show ways I am able to currently download the data, along with a "end result" sheet that shows the result of how I am trying to get this to work. Currently, all the services available to each user are separated in their own row, and this causes a lot of blank rows to be created. At the alternative, I can download Version 2, which just replicates the same information in columns A-C for each row where a new service is listed.

The end result, ideally, would just list each unique person's email address in Column A, property name in column B, and then group the services available at those properties in column C that are currently being displayed separately (example in End Result spreadsheet).

I was informed by one person that I can use the Concatenate function, however after reading more on that, I'm not sure how to apply this to my situation where there is not a consistent number of rows or pattern since some users have 5 services at their property where other users may have just 1 service at their property. On top of this challenge, my exportable list will have at least 5k unique users.

I am at a loss and my head hurts trying to figure this out. To anyone who is able to kindly assist me with this complex problem I would be forever grateful!!