If this is my datatset, arranged by Subject and Test

ID    Subjects   Test   Score     Results
1     English    1      78        Pass
2     English    1      98        Pass    

2     English    2      81        Pass
3     English    2      81        Pass

2     English    3      15        Fail 
3     English    3      74        Pass

4     Physics    1      34        Fail
2     Physics    1      79        Pass

4     Physics    2      74        Fail
3     Physics    2      81        Pass   
3     Physics    2      81        Pass

4     Physics    3      48        Fail    
2     Physics    3      15        Fail
3     Physics    3      74        Pass     

I am interested in creating summaries like this

           Test1                   Test2                  Test3
Subject    FailAverge