I have a table the contains my workers and a variety of information on each of them. They also are linked to projects that they are assigned as such.
A 1 2 3
C 2 3
Project is a multiple select column that links to a project table that shows top level detail on each project.
I would like to output to a new table that expands each of these records to provide detail on each workers interaction with the specific project as shown below:
I have attempted to use “create records from multiple select” and junction tables to no avail. I have approximately 500 workers and 200 projects and do not want to create records for every possible occurrence as my data is very sparse. Thanks in advance for your help as I attempt to navigate,