unique value in row transpose to column

[spacemananne]

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.
Anna	Smith	Analyst	Seattle
John	Doe	Manager	Dallas
Chris	Wallis	Accountant	San Francisco

Thank you!

[KOBoyle · Accepted solution]

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

[ponraj · Accepted solution]

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

WorkflowResults

[sgwong]

Seek adice on how to archeive below result.