Alteryx Designer Desktop Discussions

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

Column to Row

nkr306_nkrs
7 - Meteor

Hello Everyone

 

I am trying to convert below data 

 

NameFieldAmt
ABC123410
DEF567820
GEH901230
IJK345640

 

To

NameABCDEFGEHIJK
Field1234567890123456
Amt10203040
3 REPLIES 3
nkr306_nkrs
7 - Meteor

Can you please help.

Luke_C
17 - Castor

Hi @nkr306_nkrs 

 

Try transposing the data, then crosstabbing it.

 

Capture.PNG

 

messi007
15 - Aurora
15 - Aurora

@nkr306_nkrs 

 

 

Please see below :

 

Capture.PNG

 

Attached the workflow,

Regards,

 

Labels