We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #36: Data Cleansing Extract Authors

aiahwieder
8 - Asteroid

This was a great little Tile-and-Pivot!

Jude451
8 - Asteroid

My guess

etechman
8 - Asteroid

Good challenge

Salvatore_Miseo
7 - Meteor

Below I am attaching my solution.

I had the same approach, except for using the regex tool.

I must say that applying Regx functions save many steps and are very powerful. I will definitely deepen them.

 

 

Hub119
8 - Asteroid

Solution attached.

apathetichell
13 - Pulsar

265 columns!

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1615024794963.png

 

JP_SDAK
8 - Asteroid

my solution

Spoiler
JP_SDAK_0-1615178496531.png

 

LHolmes
8 - Asteroid

This was a fun one!

Spoiler
Liked using Multi-Row & RegEx
036 - Solution.PNG
rcarog
8 - Asteroid

Solution attached.