I have survey data that requests responses from parents about the number of kids they would like registered for an activity.
<tbody>
</tbody>
I would like to transform the data so that each child name is on a new line, but the parent name remains tied to the child in the first column.
<tbody>
</tbody>
Thank you for your help!
Parent Name | Child 1 Name | Child 1 T-Shirt Size | Child 1 Birthday | Child 2 Name | Child 2 T-Shirt Size | Child 2 Birthday | Child 3 Name | Child 3 T-Shirt Size | Child 3 Birthday | Child 4 Name | Child 4 T-Shirt Size | Child 4 Birthday |
John Smith | James Smith | YS | 41143 | Jane Smith | 4T | 43556 | ||||||
Jane Doe | Jason Doe | YS | 41143 | Sarah Doe | 4T | 43556 | Sam Doe | 2T | 43556 |
<tbody>
</tbody>
I would like to transform the data so that each child name is on a new line, but the parent name remains tied to the child in the first column.
Parent Name | Child Name | Child T-Shirt Size | Child Birthday |
John Smith | James Smith | YS | 41143 |
John Smith | Jane Smith | 4T | 43556 |
Jane Doe | Jason Doe | YS | 41143 |
Jane Doe | Sarah Doe | 4T | 43556 |
Jane Doe | Sam Doe | 2T | 43556 |
<tbody>
</tbody>
Thank you for your help!