Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI would usually transpose and filter in this case, but I thought I would skip that and find 2 other ways
Great data prep challenge
My solutions:
Difficult to find a second way to do it, utilized the Arrange tool to Transpose but it led to it becoming more manual as well.
Looking at other solutions, there are so many different ways I could have solved this. Love these type of challenges.