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

robbie0sc
メテオール
スポイラ
robbie0sc_0-1673956645536.png

 

Solved!

mirandamcgill
アトム
スポイラ
mirandamcgill_0-1673956672228.png

 

tomrob
メテオール
スポイラ
 

tomrob_0-1673956663291.png

 

MattBrandVB
アトム

First one Complete

 

task number 2.PNG

スポイラ
 
Shreya_p
メテオール
スポイラ

Shreya_p_2-1673956745766.png

 

Antlansana
アトム

 

スポイラ
スポイラ
Antlansana_1-1673956759178.png

 

Gem_VisitBritain_0456
メテオロイド
スポイラ
Gem_VisitBritain_0456_0-1673956790523.png

 

crukesh
アトム

Use Text to Column Tool filtered by , --> Remove special characters with Data Cleaning tool -->Use Date Time tool and modify the date according to input --> Use Select tool to customize the column names and select the required columns. 

corleyr
メテオール

My solution.

dakurz
メテオロイド

Solution attached