1

I have a Google Form featuring an name, date, and checkbox field capable of generating multiple choices, anywhere from 1 to 50. I'm looking to have this form filled monthly by hundreds of users.
When the data is exported to Google Sheets and multiple checkboxes are ticked, the output goes into a single field with a comma separator.

enter image description here

I've split that data using an array formula:

(=ARRAYFORMULA(IF(ROW(GI:GI)=1,"",IF(ISBLANK(C:C),,SPLIT(C:C,","))))

So that every checkbox becomes is given its own cell.

enter image description here

I would like to transpose and replicate the name based on the number of columns following the name:

enter image description here

I've tried a number of transpose, array and split formulas with no luck, and the pivot table. Since there would be several users and multiple column entries, I'm thinking that a script is needed.

Any helps would be appreciated.

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.