Merge multiple cells into a single cell

[pi_sa11]

Hi,

I have a column with having number of email id's in number of rows. I have to write a macro which will remove the duplicates from these email id's & consolidate remaining email id's into a single cell so that I can send emails accordingly.

Please find attached excel file for reference. Please note in actuals, there are 8 columns before this email id column.

Thanks in advance.

 

[Thangavel]

Hello,
You can concatenate all email cells & use removedupes function in attached excel to get all unique emails in single cell.