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

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

Screenshot 2024-07-10 232100.png

Workflow

Accepted answers

FYI.

录制_2024_07_11_12_05_41_962.gif

or:

录制_2024_07_11_12_13_56_997.gif

or:

录制_2024_07_11_12_18_51_121.gif

All comments

FYI.

录制_2024_07_11_12_05_41_962.gif

or:

录制_2024_07_11_12_13_56_997.gif

or:

录制_2024_07_11_12_18_51_121.gif

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

0711-Ryanz3653-A.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703