Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEACompleted, but seemed complex way for a simple parse. IRL would likely not join questions, just rename, parse and output.
It seems that the Questions lookup table is not correct: Age is for the 28th column, not 38th which is what is in the Data...
I did get the same results but also started working on an alternative solution that could actually allow creating a dashboard in Tableau or any other visualisation tool.
Got myself really confused by the question and the output, but got it in the end quite simply