Like others on this post, I feel like this challenge kicked my butt. I was able to get the final output to match, and I'm guessing it could have been done with fewer tools. Still, I'm happy I completed this challenge. It gave me exposure to some new data shaping techniques I hadn't encountered before and forced me to use some tools I don't use every day.
After having submitted... I looked at the others and discovered a tool I had never used before... (which would have simplified my solution)!
I guess you learn something every day!