Move second row to another column

I was given a list of names of addresses in an Excel file in the format below

Column A Column B

Name Street Address Suite
City State Zip

I can remove the merge from column A but how do i get the city state zip in the rows to column C in the appropriate rows?

Parse

Help

Accepted answers

Please see below for the workflow:

This is the dataset

And the workflow is pretty simple

You then can see how we locate the row with the info that is supposed to be column C and assign it to over there.

Pedro.

Move second row to another column.yxmd

All comments

Please see below for the workflow:

This is the dataset

And the workflow is pretty simple

You then can see how we locate the row with the info that is supposed to be column C and assign it to over there.

Pedro.

Move second row to another column.yxmd

Thanks Pedro, this does not work with actual addresses, so i changed the field3 to 250 length and it works.

My other problem is now i need to parse out the city,state,zip field because i need to perform an address match to our database. the CASS tool will not export out the city, state,zip in separate fields like i had hoped. any ideas here?

I am able to parse out the state and zip into separate fields but how about the city? the cities with two names separated by a space are giving problems.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703