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:
-
Glad to share link to my sheet if that would help. docs.google.com/spreadsheets/d/…– Steve BrownJun 23 at 17:13
-
Welcome to Web Applications Stack Exchange.– doubleunaryJun 23 at 21:53
1 Answer
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.
-
Good job,doubleunary. Before using your formula he will have to modify the row (or rows) that contain a double Block, such as cell B21, and add a new row, so that he can then extend the calculation to the whole WhatIGot!A1:C– DanieleJun 23 at 22:22