Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transform Tools - Rows to columns

AmAm
7 - Meteor

Hi,

 

I am trying to shift the rows into columns. I know that I should use transformation tool, I tried few but it did not work. So I want some help plz. 

 

Thank you in advance,

 

I have this 

AmAm_0-1651082483649.png

and I want this 

AmAm_2-1651082551258.png

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @AmAm,

You need to have name as a key column and the rest as data columns. Like so (I've attached an example workflow):

IraWatt_0-1651082860022.png

The key columns will remain the same and the data columns will pivot round them. 

 

AmAm
7 - Meteor

@IraWatt Thanks man!!

IraWatt
17 - Castor
17 - Castor

No worries at all ! :) 

Labels
Top Solution Authors