We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transposing groups of columns into multiple rows

blitzmonkey
5 - Atom

Hello!  I am a relatively new user and I am trying to do some self-practice.  Currently, I have a data set that has a State listed and then in the same row, has a rank from 1 to 10 of some names followed by a sum amount of those ranks in the same order followed by a percentage in those ranks in the same row. 

 

 

For example.   AZ   Company A   Company B  Company C  1000  900  800   60%  30%  10% 

What I want to do is transform it so it says this:

 

AZ Company A  1000 60%

AZ Company B 900  30%

AZ Company C  800 10%

 

How could I accomplish this?

 

Thanks!

2 REPLIES 2
binuacs
21 - Polaris

@blitzmonkey One way of doing this with the Tile tool

binuacs_0-1674844288889.png

 

blitzmonkey
5 - Atom

Would I do anything different if there were multiple states?  

 

Oh, I got it.  I just cleansed the data first.  There were some Null/ NA fields causing issues.  

Labels
Top Solution Authors