Converting sub rows into sub columns [Closed]

Report
-
Hello,

I have consolidated data in excel, except I need to change the layout it is displayed as. Is there a way to change this layout or to write a macro?

The data I have
School Year CountOfActive
Book1 33
Book2 45
School A 78
Book1 38
Book2 19
School B 57
Book1 30
Book2 25
School C 55
Book1 17
Book2 7
School D 24
Book2 16
School E 16
Book1 9
Book2 2
School F 11

Book1 2
School G 2

I need this to instead look like this:

School, CountOfActive, Book1, Book2

School A 78 33 45
School B 57 38 19
School C 55 30 25
School D 24 17 7
School E 16 0 16
School F 11 9 2
School G 2 2 0

I want the Book 1 and Book 2 data values to be columns not rows above the subtotals.

Cheers

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!