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 #23: Parsing CPG Data

AngelosPachis
16 - Nebula

Nice challenge! My solution for challenge #23

 

Spoiler
Annotation 2020-08-28 120404.png
JoePC
9 - Comet

Solution Attached

BobHabbijam
8 - Asteroid

Almost - well not really but I'm happy with it 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

This is a typical Excel struggle pattern. I've gotten used to it because I've suffered so many times...

I made 2 pattern.

 

Spoiler
Pattern 1: Use arrange tool.
Pattern 2: Use CrossTab and Transpose tool.

AkimasaKajitani_0-1599368320430.png

 

myouree
8 - Asteroid

Solution attached.

Per
11 - Bolide

Would have been prettier with a macro, oh well

Tokimatsu
12 - Quasar

Solved.

Spoiler
2020-09-21_13h09_29.png

LHolmes
9 - Comet

I feel like I just took a ride on the Tea Cups at Disneyland - not the sort of thing you want to do after having yogurt. This was a good workout.

 

Spoiler
023 - Solution.PNG
Qiu
20 - Arcturus
20 - Arcturus

It was brutal!

Spoiler
en23.PNG
Sashikumar
8 - Asteroid

Nice.

Spoiler
ch23.PNG