Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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