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

How to Transpose Single Row of Data

Gandalf_NotGrey
8 - Asteroid

Hello, I have a row of data with four fields such as below - 

Sum 1Sum 2Difference between Sum 1 and Sum 2Statement
34439Difference between Sum 1 and Sum 2 is 9

 

I want to convert this as shown below - 

Sum 134
Sum 243
Difference between Sum 1 and Sum 29
StatementDifference between Sum 1 and Sum 2 is 9

 

Is this possible in Alteryx?

Thanks so much in advance.

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @Gandalf_NotGrey, if you just connect a Transpose tool and leave the configuration at the default (i.e. all columns ticked as Data Columns), that should do the job.

Gandalf_NotGrey
8 - Asteroid

Thank You @DataNath 

Labels
Top Solution Authors