To add another equation to your tool box of Google Sheet equations, watch the video below where you can learn all about Transpose Filter. Transpose Filter can work like a Vlookup to pull in data from one sheet to another, based on a unique value such as a student ID or other identifier. Vlookup however only pulls in the first instance of the data and Transpose Filter can pull in all instances and place the data in one single row to make it easier to read.
Watch the video below to learn about Transpose Filter. You can also go to bit.ly/sheetsmagic to play with some sample data and you can also find all of my other Sheets videos at https://www.youtube.com/playlist?list=PLpkqNHvNE0Sl8seEkvLPiko4pwKvZZxIC