I am looking to manage a wellness challenge, team format, using Airtable. The team registration survey returns one row per team, with data about that team in separate columns. There are extra columns in it (like survey record #) but these are the ones I am interested in:
Team Leader Leader email Member 2 Member 2 email (etc up to 10 members) Organization
Basically each member email is a unique identifier/lowest level, and each email has a member name, a team, an organization, a team leader/email, and eventually 8 weeks of data that should be received. Teams are at least three (leader plus member 2 and member 3) up to 10. So some of the fields will be blank after member 3.
I want to extract the members and their corresponding data from the survey results. Is that possible in Airtable ?