Hello,
So I created a form to collect multiple items and it collects into a sheet, and all the data in each form is placed into one row. Is there a way to collect data and have it enter the data into columns?
for example:
form 1: has 5 sections, it all flows into one row
heading, row 1, question 1, question answer, question2, question2, question answer, question, question answer 3
How can I collect the info to;
form:
heading;
Column 1:
Quesitons
- row 1 - question 1 answer
- row2 - question 2 answer
- row3 -question 3 answer