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 #63: Data Preperation Using Pivot Tools

Quasar
 
Alteryx Certified Partner

Follow my solution file attached...

 

Spoiler
Alteryx Challenge 63.PNG

 

 

 

 

Asteroid

I'm sure there's a more elegant solution to my one here. Looking forward to reading through everyone else's. :)

Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_63_spoiler.png

 

Fireball

Good, useful practice! I'm pretty sure we've all had to work with an Excel file like this at some point!

 

Spoiler
Capture.PNG
Asteroid

Tricky fiddly, but got there in the end 

Nebula
Nebula

Slightly different form most in that I treated both header rows together.

 

Spoiler
Solution 63.png

Dan

Quasar

Absolutely certain there is a MUCH simpler way to go about this, but hey, it's early and i'm not fully functioning mentally just yet.

Quasar

Repeatable, but my joins got a bit twisted :)

Spoiler
Challenge #63.PNG
Asteroid

Here is my solution. Might not be as slick as others which I need to dig through.

 

Spoiler
image.png