Concatenate Columns by Rows

Perhaps add a column which concatenates the row, and then concatenate that column?

So in this case, you would add a column, perhaps called Summary which is =Concatenate(A, B). And then you write a formula in the canvas which is =Concatenate(Summary).

Just as a side note, you can address cells by doing =@row.column.

3 Likes