I’m attempting to restructure my exam result tables..

Hi, I’m attempting to organise an exam/date/result record list from the top layout to the bottom. Link to an image of example tables: https://ibb.co/v4BKL45S

So that the data results in one name followed by the exams attended and the date they attended on and the result scored. Each person can have around one to twelve events and is not consistent by any metric, and multiple people have attended the same exam multiple times.

Is there anyway to do this simply? Or will it have to be a manual process as I’m trying to avoid doing so, as I have close to 37,400 attendees for this period alone.

Any help appreciated and please let me know if I need to be clearer on anything. :)