Challenge #33: Reshaping Nielsen Data

[carmenrapariz]

Spoiler

[carmenrapariz]

Spoiler

[DanTh]

Spoiler

Can't say I loved this one. I spent far too long trying to identify where the station codes were hiding, only to find out it was a positional list. I could definitely go through this to tidy up blocks I don't need. 

3/5

[ARussell34]

This was not a fun one and my solution is probably way longer than needed, but I did it!

[MatthewBr]

always interesting shaping data where you have no idea about the data. 

[bjkay30]

This one was interesting.  I thought it was going to be more complicated than it actually was.  Once I figured out the pattern though, it came together pretty quick.

Spoiler

[Ukashi]

Well - got some problems with solving this one at a start - I was not quite sure what is needed - once figuring this one out it got easier 🙂

Spoiler

I do not have a chance to use select records tool very often 🙂

thankls for challenge 🙂

[pdave87]

RegEx lessons are magnificent 🙂

PFA my solution without RegEx, left it 'as is' as a part of learnings.

Thanks to all SMEs for this exercise.

Regards,

Pratik

[Luke_C]

Spoiler

[LiuZhang]

Spoiler

Not very dynamic in the workflow, but it was pretty tough to get it cleaned in the first place, so I will take it to get the required form.