How can I add column values from several rows to one concatenate text

AppSheet AppSheet Q&A
1

Hi experts.

I would like to create a concatenated text consisting of values of several rows in the same table, which meet certain conditions based on the value of the selected row.

I think this will choose rows to pick data from:
FILTER(“Aranžmani”, and([Start date]=[_thisrow].[Start date], [IZLET]=[_thisrow].[IZLET], [VODIČ]=[_thisrow].[VODIČ]))

Then, from those rows, I want to pick values for [Start date], [IZLET], [VOZILO], … grouped by the row they are extracted from and create a concatenated text, which I will later use as a WhatsApp message.

Any ideas?