JOIN

Combines values from a range into a single text string with an optional delimiter. Most useful when combined with COLLECT() to create filtered, delimited lists.

=JOIN(range, [delimiter])

=JOIN([Tags]:[Tags], ", ")
=JOIN(COLLECT([Name]:[Name], [Team]:[Team], "Sales"), " | ")