Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

yzjfhls
5 - Atom

Hi everyone,

 

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

 

Current Data

GroupSub-Group 1Value 1Sub-Group 2Value 2
Group AA110A215
Group BB120B225

 

I want the data to be like:

GroupSub-GroupValue
Group AA110
Group AA215
Group BB120
Group BB225

 

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

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@yzjfhls 
Hope this is what you need.

1208-yzjfhls.PNG

yzjfhls
5 - Atom

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

Qiu
21 - Polaris
21 - Polaris

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

Labels
Top Solution Authors