Challenge #49: Reformatting Transactional Data

[HardikJani]

I first split all the product, market and type then used a combination of cross tab and append to get the data for each of the letters A,B,C,D. And then joined them using union. King of basic solution but I love looking at better solutions to learn from them.

[Spurs]

Spoiler

[Arjunmarwaha09]

Spoiler

There goes challenge_49

 

[Ray_Pospisil]

nice transpose/cross tab exercise

[scooby_snacks]

My solution. 

[Goddenra]

Good practice of cross tabs which is always a bit of a tricky thing for me.

[mshahid]

Challenge 49 Completed

[mshahid]

Challenge 58 Completed

[AImbody]

Spoiler

[helenxu1975]

Spoiler