Challenge #20: List Parsing

[Jonathan-Sherman]

Glad i've been practicing my RegEx, otherwise this would have been extremely difficult!

Spoiler

[ArnavS]

Was pretty forced but came to the correct result

[jusdespommes]

This was horrible. End of. :'(

Spoiler

[sgrabish1]

Done; easy to do with answers nearby

[mbogusz]

Tried my shot at @SeanAdams's way, with process of elimination, and got close, but not quite there.

Spoiler

[RoDO]

My solution

Spoiler

[mat_budden]

Hi All,

Please see my result below.

Spoiler

Started the hard way using formulas, Then realised i should use Regex, So used regex in the end, after concatenating the fields using a multi row formula.

Thanks

Mat

[Parul_Kapoor]

Solution attached.

[nickjastrzebski]

Not quite 100% there, but as close as I could get. This one was very tough with the various inconsistencies within the data.

Spoiler

[ZenonH]

I tried to come up with a workflow that would remove and add extra lines to make the data line up into groups of 6 rows, but couldn't get that going smoothly. 

Here's what ended up working (:

Spoiler