Different data in a column to on row

[RVillarreal]

Hi,

Everyone,

In need of some expertise.

Current Data Output to Excel Want to put in singe Row 

Owner Code	Owner Name	Previous Address	Current Address	Active
123-JD	John Doe	John Doe	John Doe	Y
		123 Sesame Street	123 Sesame Street
		Manhattan,NY  10128	Manhattan,NY  10128

Owner Code

Owner Name

Previous Address

Previous Street

Previous City

Previous State

Previous Zip

Current Address

Current Street

Current City

Current State

Current Zip

Active

123-JD

John Doe

John Doe

123 Sesame Street

Manhattan

NY

10128

John Doe

123 Sesame Street

Manhattan

NY

10128

Y

Output Data 

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

Thank You

Rolando

[GaneshBo · Accepted solution]

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

[RVillarreal]

Thank You so much for your help.