I'm trying to make a pivot table that summarizes a teachers grade book of letter grades. Each column of the gradebook contains a different assignment. So far, I have to make a pivot table for each assignment. Dragging more than 1 assignment title into the row or column fields area of the pivot table makes it confusing to read. The only solution I can come up with is making a really long spreadsheet and displaying each assignment below the previous assignment. What am I missing. Surely, there must be a way to summarize a teachers gradebook of letter grades with a pivot table.
Thanks,
Ben
Thanks,
Ben