Hello,
I am trying to develop a macro that will concatenate strings and separate them with commas in one cell and delete duplicate

Example:

ID Name Region Area
23 Red US East
42 Blue Aus NA
324 Green US North
243 Purple US All
243 Purple Can All
32 Black US West
23 Red Can East

What I would like:

ID Name Region Area
23 Red US, Can East
42 Blue Aus NA
324 Green US North
243 Purple US, Can All
32 Black US West

The issue I am running into is that I can't set a macro to concatenate easily because there are columns before and after the column I'd like to concatenate. Any assistance in this matter would be greatly appreciated. Thanks!

I am also attaching an excel example of this.

Sample1.xlsx