Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #63: Data Preperation Using Pivot Tools

SJKIM
8 - Asteroid

Completed - 2 Way

mshishido
8 - Asteroid

nice one

karlhansen
9 - Comet
Spoiler
solution_63.png
rapetter
8 - Asteroid

Done

cmoussa
8 - Asteroid

WF.png

 

fluteman
9 - Comet

I used some macros to make the transformation cleaner.

 

I couldn;t figure out how to make a dynamic iterative macro based on column #. I started it, but sputtered.

robert-headington
8 - Asteroid

#63

martinson
11 - Bolide

Cool

Cheers,
martinson

LinkedIN

Bulien
myastarling
11 - Bolide

Here's my solution. I feel like this could be a lot more efficient than what I did here, but it got the job done.

Tofel
9 - Comet
Spoiler
Challenge 63.jpg