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

euginalim
6 - Meteoroid
Spoiler
Spoiler.PNG

Might have gone out of my way to get this done...but at least it works dynamically~!

Greg_Murray
12 - Quasar

Not my prettiest. Solution attached.

alexo
8 - Asteroid

I did this with only a single transpose/cross tab, but I don't think my solution is 100% reliable - it relies on the columns being in a specific order to generate headers.

Marcel_Gavrila
8 - Asteroid

Hello, this is my solution.:)

Spoiler
Capture.JPG
phottovy
13 - Pulsar
13 - Pulsar

Fun challenge!

 

Spoiler
ph_solution.PNG
Dow_Umbach
5 - Atom
 

 

 

 
nawaszach
5 - Atom

63-A.JPG

Rdpatel
5 - Atom

It was difficult to get anything different.

Cosmin_S
8 - Asteroid

Thank you.

fmeo
8 - Asteroid
Spoiler
63.PNG