I have a table (Master sheet) in Google Sheets that looks something like this:
I need to filter out an entire row of information on a separate sheet (Last Lesson) but only pertaining to someone's last lesson, eg. Sam and his third lesson. I've tried to add various different things to my filter option but with no success. My knowledge of Excel/Google Sheets is basic so if there is another way to go about this without the filter option do share.