I am collecting scholarship recipients in a Google form. The recipients names are in a checkbox format, as some donors give to multiple students. I need to separate out the names into additional rows, but keep the corresponding data (amount, name of scholarship, etc.). This form also has student's names so I can't share it to get the specific help. Anyone willing to help me out?
It is a similar issue as found here: Simplifying Google Form Checkbox Responses into Itemized List
I have made a makeshift sheet without sensitive info. Form Responses tab shows how the responses come in, and the Awards by Student tab shows how I need them to be. Find it here.