Good Day Experts!
I have been tasked with another assignment that I need some help with. Hopefully you can point me in the right direction.
I have a list of students that each have 4 classes. So far we have made it through 3 quarters. However, the student could have moved here at the start of the second quarter so would only have 2 quarters in the books. When the class changes, I have to avg the grade percentage for as many quarters as the student was enrolled. All of the class grade percentages need to be on one line per student. I have attached a file to try and make it clearer for what I am trying to achieve.
What is the best way to approach this?
Thank for the help,