Challenge #33: Reshaping Nielsen Data

[JasonHu]

Spoiler

Here is my submission for challenge 33, realise that regex is the best way to solve it.

[TraceyD]

It was very difficult to interpret the data in this one.

[OnionKnight]

solved.

[aiahwieder]

Oooof, this one took me right back to my publishing days! So much messy messy data . . .

[byagelski]

my solution...found the multi-row tool was completely unnecessary once i finished the outputs...didn't immediately realize that the date fields were already in the Code and Program data parsed at the beginning of the workflow. 

[danettedavis]

solved

[Hub119]

Solution attached.  This one would have been a real pain if hadn't known which data rows to be looking for.  Thankfully, the actual data I get from Nielsen comes over structured much better than this 🙂

[ReconBen]

Spoiler

 

[LHolmes]

A little brute force and maybe not the most repeatable process if the incoming data changes format - but works for this.

Spoiler

[rcarog]

Solution attached.