Remove duplicate rows and combine cells with differing values

Hello everyone,

I'm struggling with the following problem - what I have is a spreadsheet with multiple duplicate rows similar to the one below:

mail	first_name	last_name	type	display_name	team	phone
[email protected]	Mark	Stapleton	Owner	Mark Stapleton	ASD	123234
[email protected]	Mark		Member	Mark Stapleton	ASD
[email protected]			Member	M. Stapleton		0000
[email protected]	Mark		Owner			543654

Only the "mail" cells are never empty and serve as a way to identify a given user. So what I'd like to do is to remove all duplicate rows
and "merge" the cells that have differing values for a user, in other words my goal is to transform the above 4 rows into 1 that would look like this:

mail	first_name	last_name	type	display_name	team	phone
[email protected]	Mark	Stapleton	Owner, Member	Mark Stapleton, M. Stapleton	ASD	123123, 0000, 543654

Can something like this be done in Excel? If so, how?

Any tips would be really appreciated and thank you in advance for all the help.

Regards.

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

Thanks for the tip, sample workbook files have been attached.