This was tough for me. Had to go through some solutions first and then tried to apply my own tools as much as possible. I got stuck on using Transpose or Crosstab in the beginning for a while. Then after reviewing couple solutions realized you can start with simpler tools to format the data as needed.
Capstone - solution