Turning google doc single row multiple choice responses into multiple row responses

[tkennedy13]

Hi,

I have a Google Doc with one multiple choice question. The rest of the questions are identifying information. We need to convert the single row responses into multiple rows. So each "Club Listing" should have a separate row, but the other cell info should be repeated for each.

I have been searching on this site, but cannot seem to find my answer no many how many options I have tried. The issue is that some have chosen one club and some more than one (top is 5).

Does anyone know how to handle this?

Timestamp	Choose Club(s)	Student Name	Parent Name	Email	Address	Parent Cell Phone
10/12/2017 22:49:22	Photoshop (Nov 1st, 8th, 15th & 29th )	Joe A	Mom 1	email 1	Street 1	phone 1
10/13/2017 15:29:46	YMCA Sports & Team Building (Tues & Thurs/$45)	Joe B	Mom 2	email 2	Street 2	phone 2
10/13/2017 18:20:59	Ice Skating Club-Session 1 (Thurs/$80), Ice Skating Club-Session 2 (Thurs/$80)	Joe C	Mom 3	email 3	Street 3	phone 3
10/13/2017 18:25:35	Ice Skating Club-Session 1 (Thurs/$80), Ice Skating Club-Session 2 (Thurs/$80)	Amy A	Mom 4	email 4	Street 4	phone 4
10/13/2017 20:20:39	Art Club (Mon/$10)	Amy B	Mom 5	email 5	Street 5	phone 5
10/13/2017 21:11:39	Art Club (Mon/$10), Geo Bee Club (Dec 12 & 19, Jan 8, 9 & 17), Lemonade Club (Tues & Thurs), PMS Post (Wed)	Amy C	Mom 6	email 6	Street 6	phone 6

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>