Combining rows

[Tom_automated]

Is it possible to merge rows with AppSheet. If row 1 has name = fname, info=here and a uniqueid=12345, and row 2 has name = fname, info=there and uniqueid=23455, I’d like to be able to combine the columns of the 2 rows, so that the remaining row has name=fname, info=here,there and uniqueid=23423. I don’t care which uniqueid is kept or if a new one is created. Is something like this possible with AppSheet?

[Marc_Dillon]

Yes that is possible. You can build some “data: set the values of columns” or “create a new row” actions to achieve this. Couple it with a reference action to delete the other rows.

[Tom_automated]

Thanks for pointing me in the right direction.