Challenge #33: Reshaping Nielsen Data

[data_rachel]

Spoiler

I chose to leave the programme names in the original format as they looked like they had been truncated for whatever reason in the output file.

[msicak]

well this took me forever to understand! I overused the multi-row tool for sure but it gets the challenge done.

Spoiler

[jamielaird]

This one was really foxing me until I exported the source data to Excel and realised that everything I needed was in two relatively small areas of the sheet. I manually isolated these rows and the rest was simple. Doesn't feel like the most robust solution but it does the job with relatively few tools.

Spoiler

[Waynemk]

LOL. took me longer to figure out what was happening than solving it.

[JoshKushner]

Another one that took way longer than I anticipated, but I think a very good example of data blending from legacy systems.

[dsmdavid]

Clearly overcomplicated...kind of still works though so...

Spoiler

[JosephSerpis]

Challenge Completed

[asabau]

Recreated the original solution. Messy data set.

[daniel_ferreira]

Follow my solution file attached...