Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAWith columns and data in same order as desired output. What's with all the z's in the data?
Forgot to attach spoiler. Adding so challenges completed tracks correctly.
perfect use case for a macro!
I remember looking at this challenge when it was fresh and not really understanding the data set and just skipping it. Coming back to fill in the gaps of my weekly challenges I'm glad to have finally solved this (: