Google Sheets tips & tricks

Concatenate a Range

Example usage: a column with a list of email addresses

=textjoin(", ", 1, A1:A14)