How to transpose every 2 column to a new row while keeping the header ?

[yzjfhls]

Hi everyone,

I'm new to Alteryx and I am struggling with the following task:

Current Data

Group	Sub-Group 1	Value 1	Sub-Group 2	Value 2
Group A	A1	10	A2	15
Group B	B1	20	B2	25

I want the data to be like:

Group	Sub-Group	Value
Group A	A1	10
Group A	A2	15
Group B	B1	20
Group B	B2	25

I would really appreciate any input on how I can go about this!

[Qiu · Accepted solution]

@yzjfhls 
Hope this is what you need.

[yzjfhls]

That's super helpful! Thank you so much, you're a life saver

[Qiu]

@yzjfhls 
Happy to help and thank you for the accept mark.