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.
I've split that data using an array formula:
So that every checkbox becomes is given its own cell.
I would like to transpose and replicate the name based on the number of columns following the name:
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.