Looking for vlookup style function for multiple values

[Agnieszka]

Hi everyone, hope someone can help me. I need to find multiple returns for multiple subjects. Original table looks like this:
Column A - names of students (100+ with same names repeated few times)
Column B - names of courses (for example A - Z)
Column C - course submission date



I need to find out if all students did course B, D, H, O and X, and when.

Final table looks like:
Column A - names of all students
Raw 1 names of courses - 1b course B, 1c - course D…
Cells in between would search for course submission date…