Challenge #49: Reformatting Transactional Data

[geoff_zath]

Spoiler

[benjamin_feuchter]

Spoiler

[BSilverblatt]

Thanks for the challenge! Here is my solution:

[r_manju02]

Got the same solution as others

[Tubalady]

I'm getting the hang of these...  Not ready for the "Difficult" ones yet, but I'm doing really well on the "Basic" and can muddle through the "Intermediate"...

[summit_view]

Spoiler

[milton_estrada]

My Solution

[MollieC]

See my solution below

Took a little bit of time as I'm still getting my head around using certain functions

Spoiler

In the end it made sense to use the cross tab and transpose tools to reformat the product/market/type and then join them again. 

[williamclennell]

Spoiler