Challenge #49: Reformatting Transactional Data

[kelly_gilbert]

I feel like I went around the world and back with this solution! I look forward to looking at others' solutions to see how to make this more concise!

Spoiler

[CaraI]

Spoiler

Similar to other solutions except I used Select Records and not Sample.

[Calliecobbs]

Definitely different ways to approach this one! Here is what I went with:

[willstom1]

Here is my solution:

Spoiler

[Nezrin]

Attaching my solution

[JDelgado]

Getting the hang of this more and more

[kat]

Spoiler

[OldDogNewTricks]

That was a nice easy one.  Lots of pivot, unpivot, I'll need to check other solutions to find the most efficient way.

[EFran]

In real life I would add Data Cleansing Tool at the beginning. Data hardly ever looks so nice and clean :)

Spoiler