I have a spreadsheet that is not in a usable format and need help rearranging it.
It is currently formatted like the table below but with over 300 Kids and 20 clubs. This format has a lot of empty cells and its not easy to filter.
<tbody>
</tbody>
I would like my table to look like this:
<tbody>
</tbody>
Any help would be appreciated.
Thanks!
It is currently formatted like the table below but with over 300 Kids and 20 clubs. This format has a lot of empty cells and its not easy to filter.
Name | Club1 | Club2 | Club3 | Club4 | Club5 |
Kid1 | Choice 1 | Choice2 | |||
Kid2 | Choice 1 | Choice2 | |||
Kid3 | Choice 2 | Choice 1 | |||
Kid4 | Choice 2 | Choice 1 |
<tbody>
</tbody>
I would like my table to look like this:
Name | Choice 1 | Choice 2 | Choice 3 |
Kid 1 | Club 1 | Club 2 | Club3 |
Kid 2 | Club 4 | Club 6 | Club 1 |
Kid 3 | Club 8 | Club 2 | Club 7 |
Kid 4 | Club 1 | Club 3 | Club 8 |
<tbody>
</tbody>
Any help would be appreciated.
Thanks!