Google-sheets – Forms Data Manipulation Revise

formulasgoogle sheetsgoogle-forms

I came across this post that is doing exactly what I want.

We use a Google form to collect new learners to add to a store.
What I'm trying to do is have the first 9 columns repeat for each learner, with each learner going onto a new line. Again this link shows it exactly.

I modified this with my own data and it works, EXCEPT it seemingly adds additional lines when no users are left. Anyone have an idea as to why I'm getting extra lines?
A link to my working file:
https://docs.google.com/spreadsheets/d/14e6bbRDrUCE1XidTfnITvhXMpUpfiDDebyV8DSWBaFI/edit?usp=sharing

Best Answer

The formulas that you use add a row for each "learner" question even if they haven't answers.

The easier solution is to use the filter feature to hide the rows having blank "learner" data blank.

Other alternatives are the use of built-in functions like QUERY and FILTER.