Hi, I have created three sheets, 1 with student names, 1 with 12 week scores and 1 that will add later on with their current scores. I have attached images in terms of the issues I am having laying this out.
I selected one team and this works perfectly, the problem happens when I have teams that don't have the same amount of students or have too many..
Attached images which will describe the issue I am having. I thought I could join the agent name and 12 week scores but will have the same problem with the current score appearing in the right lines..