I'm needing a little help and/or guidance on making some usable information out of a data export. The export is coming from a scouting management database as a tsv (tab delimited) file that I need to bring into Excel. The problem is that each person in the database is exported as a record with their training courses and completion dates all in the same record (row). The number of courses varies from person to person and I need to be able to filter by a person's name to see what they have completed.
Attached is the native export in tsv format (had to change extension to txt to upload) and an xls file in the format I would like to see that data in.