Challenge #49: Reformatting Transactional Data

[abhishekahuja35]

Spoiler

Interesting, learned about doing transpose as in Excel

[The_Rad_Valentina]

Spoiler

[StephanieYou]

Spoiler

[jamesbodolay]

fun one

[hlee36]

Attached is my workflow and macro file I created. 

[Lenusa]

Spoiler

[bmerril6]

Spoiler

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.

[aroumpelaki]

The crosstab/transpose combination still gets me :)

[IanHealey]

Solution

[ejhaley]

Spoiler