Table A contains individual evaluations of project performance. I want to create Table B that summarizes the evaluations by Project Team (average of individuals’ responses for a specific project).
Table A fields include: Project Name I Year l Responses to Evaluation Q’s
What is the best way to link both tables so that individual responses for a specific project automatically appear altogether in 1 cell in Table B?
Below are the tables that I hope to create. All the separate responses in Table A to autopopulate in Table B according to the projects they are linked to so that I can average all responses by projects in Table B.