Turn Google Sheets Columns into Rows

How To
1

I have a google form outputting results to a google sheet. The form asks for the information of multiple to be entered. I want to go from having each person’s information in one row to having the responder info repeat with one other person’s info on each line.

I have this now

image
image2833×119 45.6 KB

And I’m trying to get to this

image
image2228×350 92.1 KB

Is there a way to iterate and/or aggregate across the columns to achieve this structure without manually putting a step for each row like this?

image
image1125×194 35.3 KB

blueprint.json (191.8 KB)

Thank you!

1 Like
2

Hey @ooc_make,

To solve this issue, I would recommend to use another Google sheet where the converted results will be pasted. You can run a process like this:

  • Every x hours search in gsheet with results from the form to search for the raw with the same timestamp.
  • Then create a new raw in the new sheet to paste there the actual data from the first sheet. In order to merge the responses, aggregate the values from the 1st sheet in an array and paste all values of the array into the right column in the second g sheet.

However, I would suggest you use a form application instead of Google Forms. For example, fallout or Airtable would solve your problem with no extra costs per response.

Thanks
Dimitris Goudis

1 Like
3

Hi Dimitris,

You’re right I think Fillout has what I need.

Thank you!