unique comma separated values base on a text match

[Country_Calc_2]

I want to return unique text values (comma separated) from column B searching each matching value in column A, the value in column A.

Columns D and E will only have 1 instance of column A value.

A	B	C	D	E
Alzheimer's Disease	BGR, CHL, CZE, FRA, DEU, ITA, POL, SRB, SVK, ESP, UKR, GBR, USA		Alzheimer's Disease	ARG, AUS, BGR, CAN, CHL, GBR, HRV, CZE, FRA, DEU, ITA, KOR, MYS, POL, SRB, SGP, SVK, ESP, UKR, GBR, USA, TWN
Alzheimer's Disease	ARG, AUS, BGR, CAN, CHL, HRV, CZE, FRA, DEU, ITA, KOR, MYS, POL, SRB, SGP, SVK, ESP, TWN, GBR, USA		Vascular Dementia	ARG, AUS, BGR, CAN, CHL, HRV, CZE, FRA, DEU, ITA, NLD, RUS, SGP, ESP, TWN, GBR, USA
Vascular Dementia	ARG, AUS, BGR, CAN, CHL, HRV, CZE, FRA, DEU, ITA
Vascular Dementia	NLD, ROU, RUS, SGP, ESP, TWN, GBR, USA

 

[Fluff]

How about

=TEXTJOIN(", ",,SORT(UNIQUE(TEXTSPLIT(TEXTJOIN(", ",,FILTER(B2:B100,A2:A100=D2)),,", "))))

 

[Country_Calc_2]

This works thanks.

 

[Fluff]

You're welcome & thanks for the feedback.