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