I have details of employees around 100 for their status on 50 questions in column , I want to analyze the data in pivot candidate wise and question wise( how many candidates failed in Q1) (Experience wise failure status) . I am bit confuse. Can anyone help me out.


Name Experience Q1 Q2 Q3 Q4
A 1 Fail Pass Fail Pass
B 2 Pass Fail Pass Fail
C 3 Fail Pass Pass Fail
D 1 Pass Fail Pass Fail
E 5 Pass Fail Fail

Thanks
Harmender