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

Multiple Rows to Multiple columns

JL-ALTERYX
6 - Meteoroid

How do I convert the "Class" Row into Columns while maintaining all the values from the "Current" columns

So just basically flipping it

 

 

 

alteryxcnb1_0-1655490294688.png

 

5 REPLIES 5
Luke_C
17 - Castor
17 - Castor

Can you attach the data instead of a screenshot? As well as what you want the end result to look like? You'd probably want to use the transpose & crosstab tools. 

 

 

JL-ALTERYX
6 - Meteoroid

I added a expected results WS

Luke_C
17 - Castor
17 - Castor

@JL-ALTERYX 

 

Yup, as expected just a transpose and cross tab:

 

Luke_C_0-1655491369033.png

 

 

JL-ALTERYX
6 - Meteoroid

Thank you so much sir

Luke_C
17 - Castor
17 - Castor

Happy to help, have a nice weekend!

Labels
Top Solution Authors