In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transpose Columns to Rows and Summarize values

mercurial_maverick
8 - Asteroid

Hello!

 

I've a workflow that results in the below output.

 

mercurial_maverick_0-1606835433039.png

 

I want the above output to be transformed to the below view. 

 

mercurial_maverick_1-1606835490910.png

 

4 REPLIES 4
tsturge
7 - Meteor

Can you attach a sample data set?

mercurial_maverick
8 - Asteroid

Hello @tsturge 

 

Please find attached file sample dataset in Input tab and desired output in Output tab

tsturge
7 - Meteor

Try This

mercurial_maverick
8 - Asteroid

@tsturge This worked! Thank you sir 😊

Labels
Top Solution Authors