Arrayformulas
Or if you want to keep it in the app and not the sheet, then use a Template column to join multiple columns together.