These are some screenshots of my final spreadsheet that I created. One of the sheets is the student and trip information, this was the sheet that I did the mst formula and the one that holds all the information about the students. Another sheet was made up of a few tables that held the information needed for the other sheets. The final sheet was a summary which I collected the information for and presented it in both pivot tables and charts.