Different data in a column to on row

Question

Hi,

Everyone,

In need of some expertise.

Current Data Output to Excel Want to put in singe Row

Owner Code Owner NamePrevious AddressCurrent AddressActive     123-JDJohn DoeJohn DoeJohn DoeY  123 Sesame Street123 Sesame Street   Manhattan,NY  10128Manhattan,NY  10128

Owner Code Owner NamePrevious AddressPrevious Street Previous City Previous StatePrevious ZipCurrent AddressCurrent StreetCurrent CityCurrent StateCurrent ZipActive123-JDJohn DoeJohn Doe123 Sesame StreetManhattanNY10128John Doe123 Sesame StreetManhattanNY10128Y

Output Data

Im new to Alteryx i have used the multi row tool to get around but need some help.

Thank You

Rolando

GBO95 · Accepted Answer

Hi @RVillarreal ,

Attached is a sample solution.

It's a little long but hope this solves your problem.

I used Regex to split the Address data and used transpose to make it more dynamic so you can use this workflow to deal with more than one data.

Best,

Ganesh