I am having a problem and wondering maybe someone solved it somehow.
I am having a column a table in Coda where one column contains cost type (like IT) and the second column that is multiple choice list, containing names of projects associated with particular cost type. The values in second are manually picked.
In another are I would like to have another table, where column 1 contains Project names and Column 2 cost types associated with the project in separate rows
So Table 1 looks like that:
Cost type | Associated projects
Infrastr | Project1, Project2
IT teams | Project1
And I want Table 2 to look like that:
Project | Cost type
Project1 | Infrastr
Project1 | IT teams
Project2 | Infrastr
Using Filter() or Contains() puts entire lists in a singe row so far.