I am trying to take a Google Form response page, and change the way the data is displayed. Currently, I have the raw data on the first sheet, and I'm trying to format a second sheet that will split the checkbox answers from the first sheet into their own row.

Form responses look like this: enter image description here

Expected output on next sheet, I WOULD LIKE TO look like this: enter image description here

The first sheet is the responses from the Google Form, and the second sheet is how I prefer the data to be displayed.

How can I accomplish this goal?

Form Response Sheet

  • Welcome. "I found this code..." Where is it from. Please share a link to it as well as your efforts to adjust it. – marikamitsos Feb 18 at 14:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.