Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAGreat challenge for transpose, cross tab and splitting your data for a more dynamic solution.
As an Alteryx Sales Engineer, I aimed for a simple and dynamic solution, renaming only 3 columns manually.
I struggle with rather to determine column names dynamically, or just use SELECT tool and rename them that way. I sort of did both here - so probably could have simplified and used less tools on the last 6 columns...
Attached. Almost reworked the whole thing, as I felt I made it too complicated, but decided to leave it. Interesting use case for the Arrange tool, in my method, so I've got that going for me.