Tranform address label data

[lmaughan]

I have address data in a file that looks like this:

First Last Name

Address Line

City State ZIP

First Last Name

Address Line

City State ZIP

First Last Name

Address Line

City State ZIP

First Last Name

Address Line

City State ZIP

I need to transform the data into a table format that looks like this.

First Last Name               

Name	Address	City_State_Zip
Joe Smith	123 Anywhere Street	Anytown, CA 92103
Debbie Hansen	534 Anywhere Street	Anytown, WA 80329
Henry Somebody	485 Anywhere Street	Anytown, TX 54367

I can parse the City_State_Zip using Text To Columns, but I am struggling trying to just transform the data from label format to table.  Help is appreciated!

[grazitti_sapna · Accepted solution]

Hi @lmaughan ,

I hope this helps, attaching the workflow along with the screenshot of the desired output.

[lmaughan]

Thank you!  I was trying the transpose and crosstab -- but I didn't have the full picture of what to do after that.  Your workfile was very helpful!  Thank you for taking the time to mock this up. Much appreciated.

[grazitti_sapna]

Hi @lmaughan , your most welcome. Happy to help!