Hi all,
I need help on a survey table that is of following format. Sr# contains 318 rows and there are 30 columns named 1 through 30. I want to create a summary using 'pivot table' that helps me in identifying how many questions have an answer 'a', 'b', 'c', 'd', and '0'. Would appreciate a quick turnaround as I need to submit the results for my dissertation.
<tbody>
</tbody>
I need help on a survey table that is of following format. Sr# contains 318 rows and there are 30 columns named 1 through 30. I want to create a summary using 'pivot table' that helps me in identifying how many questions have an answer 'a', 'b', 'c', 'd', and '0'. Would appreciate a quick turnaround as I need to submit the results for my dissertation.
Sr# | 1 | 2 |
1 | a | b |
2 | c | d |
3 | 0 | b |
4 | b | c |
5 | a | a |
6 | b | c |
7 | d | 0 |
8 | a | c |
9 | b | d |
10 | a | 0 |
<tbody>
</tbody>