Challenge #23: Parsing CPG Data

[AlexC2]

solution posted, also reformatted date and numeric fields

[FlorianC]

A practical example to parsing Excel data.

Spoiler

Workflow

[PhilBalderson]

I didn't look at the solution until I'd had a go. I'd guessed that a transpose and crosstab could have avoided my slice and dice attempt! 

Spoiler

[Tberney]

Tough one. Had to use the data analysis tools to have any confidence I was even recognizing the pattern

Where did the spoiler control go?

[danicahui]

Spoiler

[szade1]

Took the long rout, but got there.

Attached my solution.

Thanks,

S.

[phottovy]

Very curious how others solved this one.

[mollymargolis]

my solution

[JethroChen]

Spoiler

[GaneshBo]

My Solution: