How can I get the survey results below shown as second table below? Idea is to capture names of associates who answered "1" in a single cell.
Raw data:
<tbody>
question 1
question 2
question3
Associate1
1
1
2
Associate2<strike></strike>
3
1
1
Associate3
2
2
2
Associate4
3
3
3...