Challenge #33: Reshaping Nielsen Data

[martinson]

Tough question

[Dhrish]

Spoiler

[Dominic_Brady]

The actual solution isn't too bad.. hard part with these is understanding what on earth the initial data format is!

[TGreen]

Solution submitted.

[JBevan89]

My Solution attached.

[Bennu]

1 toll only solution.. doesn't get easier than that...

Spoiler

[RebekaMazuchova]

:)

[Rhys_Cooper]

Brain tickler to workout the pattern of the input data. Good reminder of the importance of taking your time reviewing data before keyboard smashing out a solution! Thought the final step of manually relabelling the fields in a select tool is undynamic so made a better solution to fix that.

Spoiler

[Pilsner]

My solution:

Spoiler

 

[jrlindem]

Felt like this one's solution file took some liberties due to familiarity with the data file, but hey, we've all been there too right?

Spoiler