Cross tab mutiple key columns

[wenyg]

Hi

  Can someone help with transforming data from sheet 2 to sheet 3?

Thanks

[BS_THE_ANALYST]

@wenyg here's one way:

[wenyg]

@BS_THE_ANALYST 

Thanks, this is very helpful. How can I add the rest of headers in? such as Allocation Dim, currency, company code etc.