Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAstill not regex-ing and had to have a peek at the solution to figure out how to get the pivoting to work...
This has been the toughest challenge for me so far, and I will have to admit that I have spend quite some time on this, since I did got stuck.
My solution clearly falls into the catogory, that shows, that in Alteryx there is many ways to get to the same end result.
I am not happy with my solution, but my result matched up with the provided output, and here it is
I will most definable take a look at the other solutions provided (especially #1 @NicoleJohnson 😄), so I can get wiser.
//Thomas