In my first table, I have Projects: A, B, C. They are single select tagged as Locations 1, 2, 3. They are tagged with Persons (a Linked Table).
In my second (Linked) table, Persons. All the Projects are automatically combined into one column.
Users will input data in the first table. In the second table, I need each Location to be a column header, so that each Project is parsed across those location columns.
In short, I need the tags in the first table to be the column headers in the second table.
Help would be appreciated!