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)?