How can I search a range of text and return value of text from first column?

I want to search a range of text (exams students have signed up for) and create a list of students who have signed up for each exam.  I would like it to look similar to the table below.  Can anyone r...