Challenge #33: Reshaping Nielsen Data

[Chantelb]

Spoiler

[AndrewS]

#33

Spoiler

[johnemery]

Very tricky. That data format was horrible!

[LindaLo]

I used a long time on determine the header name...

[sonyakasenkramer]

Not the best solution, and they'd better never change the number of header or footer rows. I could have done better with filtering out data rather than sampling, but the format just made me so angry i wanted to be done with it.

Spoiler

[AdrienGohy]

Here is the solution I used.