hitry this
Excel Formula:=TEXTSPLIT(TEXTJOIN(";",,F2:F4),,";")
HiWhat version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Thanks for that.365 , updated in my profile!
=UNIQUE(FILTER(A2:A100,A2:A100<>""))
=MAP(E2#,LAMBDA(br,TEXTJOIN("; ",,FILTER(B2:B100,A2:A100=br))))