Google Sheet Equations = Transpose Filter (like vlookup for multiple entries)

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 to play with some sample data and you can also find all of my other Sheets videos at