Formula that lists all columns value of a row?

Hey @Antoine_Morisetti!

Chances are, you should have approached your data differently. What are those 50 columns? Is it something like dates? Because in a case like that you should’ve designed your table as one row per cell (with a column for a date) and group by date in top.

Can’t find a more recent implementation of this but here’s the idea:

If this doesn’t work and you actually need to combine the columns, one way to do this is with a custom pack. The pack would read a row from the Coda API and return all cell values as a single array of strings.

Finally, there’s black magic. But it goes far beyond “simple”.