Create columns in a new table from rows in another table

1

I have tried to search on this topic but havent been able to find the right solution. What I am trying to do is take each row value from my display column in Table 1 and populate a Table 2 with a column for each row value.

For example:
Table 1
apple, 7, 10
banana, 8, 12
pecan, 13, 26

I would like to dynamically create the columns in Table 2 so that there is column for apple, banana, and pecan. Ideally if I add a row to Table 1 then a column can be added in Table 2.

2

Hi Bryan,
I’m not sure of any internal solutions but would the Formula Tables pack be what you’re needing?

1 Like
3

Hi Brian, this sounds like you come from Excel and are trying to replicate Excel patterns in Coda. But Coda is more akin to relational databases. Programatically creating new columns doesn’t make sense for the vast majority of use-cases.

I think you would benefit from taking a look at this link: Transitioning from Excel - Part 1: Layout | Coda Help Center

Hope this helps,

Pablo

4

Thanks, Ill give this a review

5

Agree with Pablo. You don’t say in your post WHY you want to duplicate the entries.

Consider creating a single table with views.

1 Like