Challenge #63: Data Preperation Using Pivot Tools

[Karam]

My solution ..

Spoiler

[sachin02]

My solution:

[Sajeel_Kershi]

similar to provided solution

[cplewis90]

A lengthy solution to work through this one. I definitely look forward to seeing other solutions to see if there is any simpler solutions.

Spoiler

[ahmadtookhy]

Check out my solution.

I am pretty confident no one did it in that way before me :)

[hanykowska]

Mine is not a pretty or concise solution but seems to work...

[JonathanAllenby]

Here's my solution to challenge 63.

[KMiller]

Solution attached.

Spoiler

[pedrodebs]

My solution.

[StefanWe]

Attached my Solution. I added a formula to calculate the total point of sales if missing. Additional Idea: could be extended to validate the data.