Challenge #23: Parsing CPG Data

[greggrimmer1]

Spoiler

[A2H]

Spoiler

[WernerE]

Completely overdid mine but seeing some of the other solutions and how they came to the answer will help me shorten my builds in future. The challenges are awesome, keep them coming please. I have learned so much by doing these challenges and working through the forum. 😁

Spoiler

[p-g]

Transposing, pivoting and unpivoting was fun! My solution.

Spoiler

[DN]

Spoiler

 

crosstab / transpose /crostabsss this one is brutal

[gguedes1]

Spoiler

Hello,

Above is my solution for the challenge.

I'm in the process of training for my advance certification and I thought it would be better to use the regex tool as part of my training. If anyone wants to discuss the workflow please reach out. I will be more than happy to discuss further.

[PhilipMannering]

Solution attached.

[aiahwieder]

This one was super realistic, I spend a lot of my time breaking up data in this fashion (in Alteryx, of course, never by hand . . .)!

[TraceyD]

Not the most elegant solution...

[clmc9601]

Batch macro made it easy to select and union!