Thread: Skip Repeats without Deleting w/Multi-Criteria involved

So I'm trying to create a sort of transcript-type report for my students, but I'm having a bit of a difficult time.

I use an online database called PowerSchool and it stores the grades for all the students in the program in that database. When I export the grades, it comes out as a huge list stating the grade/class/letter grade, tons of info. The one problem is that it gives me information for the same class in different rows. So the list would look like this:

Student___ Grade___ Class___ Term___ Letter Grade
PS Dude___5th___ Math____ 1st ___ A+
PS Dude___5th___ Math____ 2nd ___ B+
PS Dude___5th___ Math____ 3rd ___ C-

So it looks something simple, except that it exports hundreds of kids information and it's all jumbled up.

What I would like the report to look like is:

PS Dude - 5th Grade
Subject___Term1___Term2___Term3
Math___A+___B+___C-

I've tried INDEX/MATCH and an assortment of other formulas, but I can't seem to be able to just skip any repeat classes and consolidate that letter grade information into one row only.

I've attached a sample workbook (much simpler that the real one), so that hopefully you guys can help me out. Thank you so much! I apologize in advance if it seems a bit confusing what I'm writing.