This challenge taught me a lot about regular expressions and how RegEx tool work.
Also, after seeing the solution I realized better how the Summarize tool work and a great use of Transpose tool, which I have some trouble yet, was exemplified too.
In summary, these challenges are helping me a lot to get confident in my way for alteryx core certification!
Follow my suffered version to solve this problem before I have seen the solution. :-)