Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
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