How to Turn Data in Rows into Data in Columns but only when the rows share a key element in common (Pivot a table into a matrix?)

Question

My student information system gives me multiple rows per student, each row showing one period in their schedule. I want rearrange the data so each row is the complete schedule for one student. Put another way, my source gives me:

What I want is this:

Answer 1

Use query() with a pivot clause, like this:

=query(A1:C21, "select A, max(C) where A is not null group by A pivot B", 1)

If you need to handle multiple blocks listed in one cell in column B, you will have to split the column and insert additional rows.