Dynamically convert column values to column headers

[mercurial_maverick]

Hello all,

Sheet 1 on attached file has 3 columns. Tracking number, Date, Resolution codes. I need this to be transformed to show "Resolution code" values as new column values depending on the number of resolution codes per tracking number. For example, if tracking number "A" has 4 resolution codes values then create 4 column headers code 1 , code 2, code 3, code 4 and display the values under them. 

Desired output sheet is an example of how the output needs to be.

[AngelosPachis · Accepted solution]

Hi @mercurial_maverick ,

Would this work in your instance?

Regards,

Angelos

[mercurial_maverick]

@AngelosPachis Perfect, thank you sir!

[AngelosPachis]

Anytime @mercurial_maverick