Row data to column, with two columns of data to repeat

I have a survey for teams registering for a competition. Teams are min of 3 members, max of 10.

The Team Members tab in the attached file shows the data export from the survey.

The Members Data tab shows what I need to extract from the Team Members tab data.

The Team Data tab is another data source I have, in case it helps to extract the Members Data

And the blank fields aren't blank when exported. They have non-printing characters.

Appreciate any help! Thanks!