Challenge #23: Parsing CPG Data

[rajenderk18]

Here is my Solution:

Spoiler

[Jude451]

I'm sure there's a more efficient way ... but I did have fun solving this challenge

[Jude451]

Solution attached

[JITHINPR]

My Solution

[Hub119]

Solution attached.  Final output is slightly different from the example as I kept the Holding Companies in the order they were provided and also kept the weeks for each subset in calendar order as well.

[robert-headington]

#23

[apathetichell]

Lots of fun!

[BeginnerMindset]

Spoiler

I've definitely missed a trick this time - used dynamic rename and dynamic select.  Must be a better way.

[jwjeong]

By  SELECT RECORD I seperated by three parts : Header(2pieces) / BODY(1piece)

From 2 pieces of Header, I blended Brand and Column Name

in order to create the key column that could seperate data uniquely when transpose/crosstab the table at the later stage

This is just a simple concept of my workflow, and please refer the posted workflow to understand the specific flow

Thank you for reading the post

_________

[rcarog]

Solution attached.