Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transpose n rows to column

NidhiAg
7 - Meteor

Hi Team,

I am kind of lost between Transpose and CrossTab here

Input Data

ColumnNameValue
A.1.a11
B.1.b22
A.2.a33
B.2.b44
C.2.c55
D.2.d33
A.3.a22
B.3.b44
C.3.c55
D.3.d66

 

I need to Transpose or CrossTab it to below form

 

ABCD
1122  
33445533
22445566
1 REPLY 1
NidhiAg
7 - Meteor

Woohhoo Solved it. Got that number in between as column and then group by using CrossTab

Labels
Top Solution Authors