JOIN COLLECT for Goggle Sheets

[bkg73123]

Hello,

I am trying to create a COLUMN E FORMULA - Looks at range B:B for Criteria from Column D and returns CONCANTENATED values from all instances from Column A.
I was doing this in Smartsheet using a JOIN/COLLECT function but COLECT doesn't seem to exist in google sheets.
Can someone help please? Thank you.

 

[bebo021999]

=textjoin(", ",true,filter($A$1:$A$12,$B$1:$B$12=D1))

Join

docs.google.com

 

[bkg73123]

THANK YOU