How to change and transpose the following table format to desired one, see details

[Ryanz3653]

Hello Community, i am trying to transpose the left sample table format to the right, (the real work is a xml format but i am finding the logic to transpose)

please provide solution in alteryx workbook, thank you very much

[flying008 · Accepted solution]

Hi, @Ryanz3653 

FYI.

or:

or:

[Qiu]

@Ryanz3653  @flying008 
Maybe we can just simply use the CrossTab tool like below?