I currently work at a college and we working to make the process of asking student clubs for information easier. We have created a google form for them to submit their member information, but each group has different amounts of members. We need the final list to be one comprehensive list of the student information, but I am not sure how to program Google Sheets to do this.
Here is what the results look like:
Here is how we need it to look:
I am not very proficient in programing but I am a quick Learner If someone could set me in the right direction. Here is the form:https://docs.google.com/spreadsheets/d/1b1VrE9Tgg_pHTFScKsOz6YgARxIMFn-3tec6Dae9hcs/edit?usp=sharing
I have tried using as ArrayFormula and QueryFunction, if someone could explain the correct formula using one of those or anything else, that would be a great help