community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #112: Organizing Survey Data

Asteroid

Love the reference to Napoleon Dynamite.  Here is my solution.

Asteroid

My Solution:

Alteryx Partner

2 solutions: one with Regex, one without.

Meteoroid
Spoiler
spoiler_challenge112.png
Asteroid

my solution

Asteroid

Here's my attempt. Next go around I will have to try out some new tools I saw others use.

 

Spoiler
Capture.PNG
Alteryx Partner
Spoiler
I imagine there's an significantly easier way to the the transpose/cross tab here, but this is what I ended up with :)
challenge 112.PNG

I tried carrying out the solution you attached. but it outputs only 19 records instead of 26. It skips the records with leading and trailing whitespaces. Any suggestions. 

 

I'll attach the macro file in another post. 

Asteroid

My solution attached.

Highlighted
Pulsar
Pulsar
Spoiler
Capture.PNG