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

James_Driver9
8 - Asteroid
Spoiler
James_Driver9_0-1649086934763.png

 

SPetrie
13 - Pulsar

Came up with a couple versions. Not sure which I like better

Spoiler
SPetrie_0-1649184039523.png

 

Tsungie
6 - Meteoroid
Spoiler
Spoiler
Tsungie_0-1649260202567.png

 

 Still working on getting better with regex expressions but got to the desired solution.

PJMartins94_
5 - Atom

See attached my solution

dYoast
11 - Bolide

I think in real life, I would generate the Total column.

Spoiler
dYoast_0-1650638953073.png

 

TonyAndriani
9 - Comet

Reposting under my new user ID.

binu_acs
21 - Polaris

solution attached

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1652871713230.png

 

Very happy to get that done. This type of challenge has given me problems in the past.

m-wolters
8 - Asteroid

My solution

mmontgomery
11 - Bolide
11 - Bolide

Challenge #63