Concatenate Columns by Rows

#1

When using concatenate, I’ve only been able to get it to work row by column [ A1, A2, A3, B1, B2, B3 ] but I’d like to do columns by rows [ A1, B1, A2, B2, A3, B3 ].
Example Table:
| | A | B |
| 1 |A1|B1|
| 2 |A2|B2|
| 3 |A3|B3|

I’d actually like to combo it up with a query, so I was trying variations of this:
=Concatenate([Table].Lookup(C, “something”).A, [Table].Lookup(C, “something”).B)

I’m new to Coda and still trying to figure out the formula language. Any ideas how to do this (or if its possible)?

#2

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