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

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