Converting data into suitable form for chart

I'm trying to import data from a rather antiquated software package of race results and present it in a line chart showing each competitor's race result against the date it happened.

The problem is the two ways the data can be exported (shown as option A & B below) is very cumbersome and I can't work out how to create a simple line chart (like the second image) from that raw data.

\1

What I want to do is turn this data into something like this:

\1

The only way I can think of is to convert/transpose the data into something like below. The problem is I don't know where to begin in trying to do that automatically.

\1

I attach the workbook shown in the screenshots which contains sample data for 5 people over 3 races.

Example Workbook: SampleData.xlsx

Any help would be very gratefully received!