Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution:
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 )