Need Help: Split One Row into Multiple Rows

[zhuyyu]

In my daily work, I need convert one spread sheet like below into different format, please help show me how to do it in Alteryx. 

Origin

Convert to 

Thanks a lot

[LordNeilLord · Accepted solution]

Hey @zhuyyu

Something like this should to the trick!

[Kenda]

Hey @zhuyyu!

There is probably a more efficient way to accomplish this, but I was able to achieve your output with the attached workflow.

Hope this helps!

[zhuyyu]

Thank you so much, I tried myself, almost got there, adding ID is what I missed, now works like a charm. Thanks again.

[zhuyyu]

Thank you too, I tried both, Neil's way is a little bit better and straight forward to read. Thanks again.