Challenge #33: Reshaping Nielsen Data

[Kinga]

hi,

Please find my solution below.

Spoiler

Two version of one solution. In the longer one I've tried to make dynamic renaming. In the second I just rename in join tool.

[JoshuaB]

Updating from my old profile

[TungThanhHo]

my solution

[leonhekkert]

I'm unsure whether just selecting rows is considered cheating, but i got there in the end. There was also, by my knowledge no way to identify which data belonged to which code/program.

Spoiler

[AndrewHoData]

Completed the challenge using mostly select tool and filter. Thought I would need to transpose, but didn't in the end

Spoiler

[geoff_zath]

Spoiler

[xspunky]

Were you able to figure out REGEX? If so, can you explain the function REGEX_Match([Field_2], '^\d.*')

[Ladarthure]

Not the most elegant way to do it, but it works :)

[JoachimCaronTIL]

Here is my solution

[mark007]

Solved! Great challenge albeit I'm not so happy about the need for so many manual changes.