I am working on creating a scoring app that allows multiple teams to participate at the same time and have several attempts at each challenge. How can I get a team’s different score submissions entered into their respective row? Scores would be entered at different times throughout the day through a form.

Example:

• 
  
  

  Team A:
  
  
  Challenge 1:
  
  
  1st Score 100
  
  
  2nd score 110
  
  
  3rd score 105

  
  
  



• 
  
  

  Team B
  
  
  Challenge 1:
  
  
  1st Score 100
  
  
  2nd score 180

  
  
  



• 
  
  

  Team C:
  
  
  Challenge 1:
  
  
  1st Score 100
  
  
  2nd score 110
  
  
  3rd score 105

  
  
  

I would like for the rows to be set up as follows:

Challenge Team 1st score 2nd Score 3rd Score


1 A 100 110 105


1 B 100 180


1 C 100 110 105