Challenge #33: Reshaping Nielsen Data

[T_Willins]

Spoiler

 

[JonathanAllenby]

My solution to challenge 33.

In the endeavour of trying to make it reusable and not hardcode field names I made a bit of a mess out of it.

[cplewis90]

Took me a bit of looking at the file and the output to see what rows were needed. 

Spoiler

[hbraunius]

My solution attached.

[TonyA]

I spent 90% of my time trying to make sense of the data in the file. I was thrown because the data appears twice in the file. I spent a bunch of time banging my head against the first appearance before realizing the data appears in a much cleaner form further down in the file. Here's my final solution.

[catherineduffy]

Solution attached

[rachelgatto]

Solved. 

[nnilz]

solution attached