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 #224: Mushroom for Improvement

Ladarthure
14 - Magnetar
14 - Magnetar

my solution 

Karam
8 - Asteroid

solution attached.

tiffanyshaw
8 - Asteroid
Spoiler
tiffanyshaw_0-1595388151060.png
pasccout
8 - Asteroid

Here is my solution

hanykowska
11 - Bolide

I think it's not the most elegant solution, but enjoyed it anyway!

 

Spoiler
hanykowska_0-1595434742245.png

 

JP_SDAK
8 - Asteroid
Spoiler
Capture224.JPG

 

This took some thought.but finally got it !

jonathangonzales
8 - Asteroid
Spoiler
jonathangonzales_0-1595512687047.png

 

naresh5315
7 - Meteor

My Response

 

Spoiler
naresh5315_0-1595568206237.png

 

coracai
8 - Asteroid

Another challenge of the week~

Verakso
11 - Bolide

Here is my submission

Spoiler
I took a peek at some of the other solutions, and also the "official" since it was available.

It seems that I took a different approach, and instead of pivoting and joining the data, I used the Dynamic Replace.

I will admit, it is a bit tricky, but IMHO it think it was more suited here
2020-07-24 11_33_46-Window.png

 If you would like to know more on the Dynamic Replace Tool, I can recommend the Tool Mastery | Dynamic Replace page

Since I did not pivot the data, I had to ad a final replace of the column names that contained the - instead of the _ in order to match the provided result 😉

On the lookout for a selfie stick 😄
/Verakso