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