In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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