Challenge #33: Reshaping Nielsen Data

[ncrlelia]

Challenge 33

[FlorianC]

I am a strong advocate for dynamicity and had to pull the actual headers from the data itself.

Spoiler

Workflow

[wwatson]

my very ugly solution but the data isn't that easy to work with

[kevin025]

Here is my solution

[JethroChen]

Spoiler

[DemandEngineer]

This one really could have used some more explanation of how the data is organized... felt like we were just left to look at the Output to try to guess where it came from.  I think in the real world we would have asked someone how the data is organized and where are the key cells.  I had an extra step or 2 to help me troubleshoot and check data matches.

Seemed like the key was realizing the important rows are those that have a dates following them in the first column of the next row.  Not easy to glean and should have come out of a quick conversation in the real world.

[JoePC]

Solution Attached

[AlexC2]

great challenge! though did not actually realise what to parse was actually all the way at the end !!

[AkimasaKajitani]

My solution.

Spoiler

The original data is difficult to understand.
 

[Emil_Kos]

Hi,

I am not the biggest fan of the select tool but it was very handy in this exercise.

Spoiler