Greetings,
I am dealing with a large data set of student scores. Both students and teachers are tied to unique course IDs that are shared between the two groups of users.
The student course ID column contains duplicates (since multiple students take the same course). The teacher course ID column contains no duplicates. Using that course ID, I want to be able to match each teacher's name with each student they teach.
My end goal is to be able to use this information in a Pivot Chart/Pivot Table in order to show score data. I want to have the teacher's associated with the correct students before I do this. It's my understanding that you should not have any blank spaces in your table prior to creating the Pivot table, but there's a good chance I'm making this overly complicated!
I've attached an example sheet to show what I have now and what I'd like to achieve. Any help you all can provide when it comes to the formula's needed to do this would be greatly appreciated.
Thanks!
Bookmarks