Return multiple deliminated values from lookup

[jimbomcmucka]

I have a data table, each row is a single file uploaded to a system. Data includes Name of Uploader (Column A), Department (Column B), Country Uploaded to (Column C). A user can appear on multiple Rows, each with different Countries.

I need to return a value of the country a user has uploaded to, deliminated in a single cell.

Eg. James | England, Scotland, Ireland
David | Germany, France
Steve | USA, Canada

Is this possible?

Thanks in advance!
Jim

 

[RobOrBob]

Hopefully this will help.

Formula at D2 is:
=ARRAYTOTEXT(UNIQUE(FILTER(C$2:C$8,A$2:A$8=A2,"")))
then copied down to D8

Formula at G2 (only) is:
=UNIQUE(A2:A8)

Formula at H2 (only) is:
=XLOOKUP(G2#,A2:A8,D2:D8,"",0,1)

 

[jimbomcmucka]

Amazing! Thanks so much.

I would never have figured that one out for myself!