Data manipulation - address parsing from rows into columns

[dataviolet]

I have data that looks like:

Field1

Name1

Address1

CityStateZip1

Name2

Address2

CityStateZip2

....

I'd like to reformat this into

Field1   Field2       Field3

Name1  Address1 CityStateZip1

.....

What's the easiest way to do this? I would think some kind of cross-tab would be required, but first I'd need to tag the fields into 3 groupings? Not sure how to do that in alteryx.

[Luke_C · Accepted solution]

Hi @dataviolet 

Try the make columns tool:

[dataviolet]

Omg amazing. Thank you so much, learned a new tool today.

[Luke_C]

Happy to help!