Challenge #49: Reformatting Transactional Data

[yilewu]

[KathrynMW]

This challenge has taught me that I really need to do more challenges with transpose and crosstab tools - suddenly found myself feeling like a beginner again!  Finally got a solution though so here it is. 

Spoiler

 

[tkisch]

Solution

[huyenntran97]

my solution for challenge 49

[KKSzpakowski]

Thank you for the challenge!
I was able to complete it.

Regards
K

[psk009]

#49 Solution: Tools used - Sample, Data Cleansing, Summarize, Join, Text to Columns, Select

[rajeshtv]

Solution

[corleyr]

Here is my solution!

[alacoume]

My solution:

[danblythe_RSM]

Spoiler

Nice and Easy