Challenge #472: School Supplies Cost How Much?! Part 1

[Tottenm]

6-Meteroid

[Amy_A3]

Complete

Spoiler

SPOILER!

[KLTerrell]

Fun! For some reason I err towards the Arrange tool instead of Cross-Tab or Transform. Those two make me fumble all the time. 

Spoiler

 

[anuelle]

Solution

[jrlindem]

Little different solve than the provided solution, but yields the same results!  Fun challenge!

Spoiler

[Ziteng]

Done 

Tip for myself: 

Data cleansing can help remove all punctuations in this case * without RegEx

[lynnesonney]

Love the Transpose tool! 

Even MORE appreciation for putting in a join that needs some work on it. This is such a hard concept to teach without examples!

[aatalai]

C472

[Dhrish]

solution

[lley124]

Here is my solution.