Combining multiple tables into a master table (vs. breaking a master into smaller ones with queries)

[Saul_MIND_Garcia]

What if you make a master table and make the others views of the master table, I stumbled across this post, I think is what you are trying to do. You just have to arrange your data in a slightly different way.

Row and Column Analysis

Hello @Joseph_B, I totally understand the frustration! I work with a lot of financial schedules and estimates which are typically (from legacy activities) setup in similar data schema. As part of my work to make past information more flexible, I have “de-pivoted” / “flattened” a lot of excel tables into something that is less table and more row-focused. This can be done automatically within excel prior to data import, and doing so allows for a lot more flexibility once you are inside Coda. I…