I've conducted a survey and exported the result. The exported data isn't that helpful. Different questions of the Survey form the first row of the excel sheet. Under every question the answers by various participants are listed. The answers are mostly Yes/No/Can't Say.
Is there any way to find percentage of answers for each question. For eg for Question 1 how many answered in Yes and how many answered in No. Would Pivot tables help?
The Sheet would look as shown
Q1 Q2 Q3
Yes No No
No Yes No
Can't Say No No
No Yes Can't Say5 AnswersSoftware1 decade ago