Transpose row data to columns

dsemitekol

Hello Community!

I know this is a popular question but after trolling the community it seems like other users have slightly more cleaned versions of what I am trying to accomplish.

So here it goes.  I have a list of people all in one column.  I want to transpose/convert the rows to columns.  Here is some sample data:

Bart Simpson

742 Evergreen Terrace

Springfield

Lisa Simpson

742 Evergreen Terrace

Springfield

Marge Simpson

742 Evergreen Terrace

Springfield

As you can see, the list follows a routine, so I feel like it is a simple formula that says, take every x number of rows and move to a new column?  So the end result would look like this:  (The pipes represent a new column)

Bart Simpson   |   742 Evergreen Terrace  |  Springfield

Lisa Simpson  |  742 Evergreen Terrace  |  Springfield

Kenda

Hey @dsemitekol! I was able to get the output you are looking for with a couple Multi-Row Formula tools and a Cross Tab tool.

First, from your input, add a Multi-Row Formula tool and create a new field called NewField with the following expression:

iif([Row-1:NewField]=1,2,iif([Row-1:NewField]=2,3,1))

Then, add another Multi-Row Formula tool with another new field called NewField2 with this expression:

iif([NewField]=1,[Row-1:NewField2]+1,[Row-1:NewField2])

Finally, add a Cross Tab tool and group by NewField2. Hope this helps!