Alteryx Designer Discussions

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

unique value in row transpose to column

spacemananne
5 - Atom

Hello,

 

I have a case where I exported data where everything is in 1 column. I was able to sequence it that every 4 rows, should be its own column

so data I have:

1.Anna
2.Smith
3.Analyst
4.Seattle
1.John
2.Doe
3.Manager
4.Dallas
1.Chris
2.Wallis
3.Accountant
4.San Francisco

 

What I want

1.2.3.4.
AnnaSmithAnalystSeattle
JohnDoeManagerDallas
ChrisWallisAccountantSan Francisco

 

 

Thank you!

3 REPLIES 3
KOBoyle
11 - Bolide

You also need to add a record id field to group by, and then you can use the Transpose:Crosstab tool.

 

Unique Value in Row Transpose to Column.png

ponraj
13 - Pulsar

Here is the sample workflow for your case.  Hope this is helpful. 

 

WorkflowWorkflowResultsResults

sgwong
7 - Meteor

Seek adice on how to archeive below result. 

Labels