Extracting the nth non-blank cell in a row

Hi

Thanks for that. Ideally I would like one row per student though, with all their classes going horizontally (with no gaps).
Is there a way to tweak your work to do it this way?

Thanks again