VBA to Concatenate one column data in excel and dedupe additional line items

[Beth0331]

Hello, Apologies if this is already on here - I did a search but was not successful in finding anything that is exactly what I'm looking for (and my VBA knowledge is limited...)

I am looking to take data I have in an excel spreadsheet and concatenate one columns data for a referenced "tag" (User ID below) in a another column. For example below, for all line items with the user ID jdoe3 i would like to combine the colors into one line and discard the remaining lines. Are you able to help me with the VBA code I would need to do this?

Currently it looks like this:

Name	User ID	Colors
John Doe	jdoe3	blue
John Doe	jdoe3	yellow
John Doe	jdoe3	green
John Doe	jdoe3	orange
John Doe	jdoe3	red
John Doe	jdoe3	purple
Jane Smith	jsmith5	green
Jane Smith	jsmith5	orange
Jane Smith	jsmith5	red
George Phillips	gphillips	blue
George Phillips	gphillips	green

<tbody>
</tbody>

I would like it to look like this:

Name	User ID	Colors
John Doe	jdoe3	blue, yellow, green, orange, red, purple
Jane Smith	jsmith5	green, orange, red
George Phillips	gphillips	blue, green

<tbody>
</tbody>

I'm using excel 2016

Thank You!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ional-line-items-post5086520.html#post5086520

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.