Challenge #63: Data Preperation Using Pivot Tools

[wincenzo]

Spoiler

[dpatnaik97]

This was tricky, it took some time.

Attached the solution.

[Oren_Soloman]

Solution Submission

[jyothiganti]

Here is my solution for Challenge#63.

[kmuralid57]

Solved.

[treepruner]

I found an article on multiple row headers that got me started and I was planning on keeping just the inside and outside data and computing the total. Then I noticed that inside + outside <> total in some cases and I went down the rabbit hole. 

Can't wait to see how people who know what they are doing solve this!

[chinedu]

My solution

[Jean-Balteryx]

Here is my solution !

[mohitch]

It took me days to complete this but finally did it. But its a long solution  🙂

[JonathanW]

Solved! That one took me a while!

Spoiler