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
rebecca_petter
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