Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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

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

@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

Happy to help, have a nice weekend!

Labels