I am trying to search within a search result to give me a particular result
Refer "desired result" below. For example, from a group of 3 students, 3
tests were given. I would like to search each student by Student ID and for
that particular Student, I would like to show the score for one of the tests.
Can anyone assist me in using functions to do this?

Data:

Sudent Test Score
Student1 Econ 12
Student1 English 41
Student1 Math 21

Student2 Econ 11
Student2 English 23
Student2 Math 12

Student3 Econ 22
Student3 English 44
Student3 Math 41


Desired Result:
Student Test Score
Student1 English 41