Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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