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 #2: Preparing Delimited Data

mindyzhang99
7 - Meteor

finished Challenge #2

shantelwalters
5 - Atom

Completed.

Yashaswi_1
6 - Meteoroid

Challenge 2 Completed

johnjankowski
5 - Atom

My solution

Divya_Bidarahalli
8 - Asteroid

Solved it.

Axiom
7 - Meteor

Have attached:

 

Spoiler
Axiom_0-1648468134612.png

 

DanielvanLeuzen
8 - Asteroid

my solution

Shutaro_Yamauchi
6 - Meteoroid

Done

aarti112
5 - Atom

i used text to columns and formulas as well as convert date/time

Debs11768
6 - Meteoroid

Hi 

I approached this as follows:

Spoiler
I used a formula to remove the quotes, and used the select tool to remove and rename data fields

Thanks

Debs