Challenge #49: Reformatting Transactional Data

[hayley9]

Here is my solution

[stan-bi]

Here is my solution! 

[varunvarma87]

Challenge 49 Completed !

Spoiler

[SahinC]

My solution:

Spoiler

[Preethi07]

I followed below process:

Transpose > Filter > Crosstab > Join

Transpose: With F1as Key field, Transpose from rows to columns

Filter : True : If F1= product, Type or Market, separate it into a new table
False : Every data rows

Crosstab :Crosstab True output to get  rows F2,F3 and F4 with its respective Product, Market and type

Join : Join True and crosstabed false output (lookup table )

[LoganC]

49 Solution

[mpennington]

Solution attached.

Spoiler

[jessle]

I always feel oddly powerful when smooshing data with the Cross-Tab/Transpose tools...