We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎06-28-2023 09:47 AM

Hello Everyone

 

I am trying to convert below data 

 

NameFieldAmt
ABC123410
DEF567820
GEH901230
IJK345640

 

To

NameABCDEFGEHIJK
Field1234567890123456
Amt10203040
Labels:
Reply
0 Likes
3 REPLIES 3
nkr306_nkrs
7 - Meteor
‎06-28-2023 09:56 AM

Can you please help.

Reply
0 Likes
Luke_C
17 - Castor
17 - Castor
‎06-28-2023 09:56 AM

Hi @nkr306_nkrs 

 

Try transposing the data, then crosstabbing it.

 

Capture.PNG

 

 

New Workflow2.yxmd
Reply
messi007
15 - Aurora
15 - Aurora
‎06-28-2023 09:59 AM

@nkr306_nkrs 

 

 

Please see below :

 

Capture.PNG

 

Attached the workflow,

Regards,

 

Transpose_CorssTab-20230628.yxmd
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All