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 #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
18 - Pollux

265 columns!

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1615024794963.png

 

JP_SDAK
8 - Asteroid

my solution

Spoiler
JP_SDAK_0-1615178496531.png

 

LHolmes
9 - Comet

This was a fun one!

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

Solution attached.