Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Interesting, learned about doing transpose as in Excel
Attached is my workflow and macro file I created.
Split into header rows and data rows, transpose both to right format, join using original column names, split product/market/type data into 3 columns, rearrange column order/type/name.
The crosstab/transpose combination still gets me :)