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 #45: Parsing Bureau of Labor Data

kcgreen
8 - Asteroid

I was stuck until I peeked at some of the solutions and saw the text to columns tool could be used for text to rows as well.   From there I just multi-rowed my way to a solution.  

 

Spoiler

 

45.JPG

 

Gauthier_B
8 - Asteroid

Done!

Was a fun challenge, took me a while to figure it out.

OllieClarke
15 - Aurora
15 - Aurora

Learnt a lot during this one :)

 

Spoiler
Challenge 45.PNG
TimothyManning
8 - Asteroid
Spoiler
45. Data Parsing Screenshot.png
robbinrv
8 - Asteroid

My workflow below

 

Spoiler
Spoiler
Alt_Chal_45.PNG
paul_houghton
12 - Quasar

Another one done :)

 

Spoiler
Challenge 45 Complete.jpg
asabau
8 - Asteroid

Nice practice of Regex!

KOBoyle
11 - Bolide

Solution attached.

dsmdavid
11 - Bolide

Went a different (and looonger road). Nested macros.

 

Spoiler
Main workflowMain workflowFirst Batch MacroFirst Batch MacroInside Batch MacroInside Batch Macro
justynam
8 - Asteroid

Challenge solved!