Challenge #63: Data Preperation Using Pivot Tools

[LordNeilLord]

Lots of RegEx practice here..

Spoiler

[jamielaird]

Here's my solution.  Slightly disagree with the posted solution -- surely "Week of" should be the start not end of the week?

Spoiler

[nick_ceneviva]

Solution Attached

[samN]

Um i think the dates in the solution file are off, but the numbers are the same? anyways not the most compact or pretty thing but does the job and should be dynamic for more columns

[ggruccio]

Getting more confident with transpose and crosstab all the time.

[LandonG]

Solution attached.

[PhilipMannering]

Solution attached. Pretty concise.

Spoiler

[jasperlch]

Solution attached.

[JosephSerpis]

Challenge Completed

[dsmdavid]

I think from all my workflows so far, this is the one with the highest ratio of dynamic renaming to other tools...

Spoiler