Mike, this video is a great help with transforming data:
Transpose, pivot or unpivot in Power Query? - YouTube