How do I get multiple scores placed into one row?

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.