Challenge #45: Parsing Bureau of Labor Data

[kcgreen]

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

[Gauthier_B]

Done!

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

[OllieClarke]

Learnt a lot during this one :)

Spoiler

[TimothyManning]

Spoiler

[robbinrv]

My workflow below

Spoiler

Spoiler

[paul_houghton]

Another one done :)

Spoiler

[asabau]

Nice practice of Regex!

[KOBoyle]

Solution attached.

[dsmdavid]

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

Spoiler

Main workflowFirst Batch MacroInside Batch Macro

[justynam]

Challenge solved!