Challenge #33: Reshaping Nielsen Data

[estherb47]

Another solution, without the need to rename fields manually. This workflow, though long, finds, formats, and assigns the header row.

[LordNeilLord]

I went down a rabbit hole with this one trying to be too clever and then realised there was a much simpler solution...

Spoiler

[nick_ceneviva]

Probably not the best way to go about it but got the solution!

[patrick_digan]

Spoiler

[Natasha]

I feel like my solution is not long, but very cumbersome

Spoiler

[dominiklz]

Spoiler

not very pretty and I lost some coloumn names in the process, but somehow got there...

[samN]

Pretty Simple reformatting and configuring

[ggruccio]

It helped to look at the file in excel first to understand how it was structured....

[PhilipMannering]

Could have reduced the tools by having the data 'flags' in the filter itself. Solution attached.

Spoiler

[jasperlch]

Solution attached.