Data Transformation

[rnguyen99]

Hi,  

   I try to convert this input to the output below. I try to use the transpose and the cross-tab tools but was not able to make it works. Please help.

   I am attaching the Alteryx project file with the input image below.

Thank you in advance, 

Robert

[binuacs · Accepted solution]

@rnguyen99 

[rnguyen99]

Thank you so much binuacs!
this is exactly what I need.