Challenge #36: Data Cleansing Extract Authors

[greggrimmer1]

Spoiler

[A2H]

Spoiler

[michael_leoni]

Spoiler

Please see my solution below. 

[phottovy]

I probably could cut out a few steps but it works!

[brandon_bunney]

attaching solution to challenge #36

[MKteryx]

Challenge 36

[StephaneP]

OK

[Romy]

Got stuck first cuz I concatenated all the rows and thought about parsing out each piece of info from there. Then realized there's a much better way of doing it. 

Spoiler

[p-g]

My 5-Step Solution to the challenge.

Spoiler

[MikeLR]

That took some thinking about

Spoiler