moving data to next column and up

[youngw]

Here is an image of my data.
I need to take all the even cells in column a and move them to B and up 1 so they match the corresponding address. Is this possible.

Ex)
A B
1234 any street
Detroit, MI 91777
1234 way street
Detroit, MI 58777
1234 ryan st
detroit, MI 99999

So I am trying to move the city state and zip to column B. I actually have a macros to delete empty cells so I could just run that on both columns after I shift the data.
Thanks!!

[youngw]

I should mention that the property address is a hyperlink. Maybe I can do an if then formula to move anything with http...
Please!

[Bryan Hessey]

Here is an image of my data.
I need to take all the even cells in column a and move them to B and up 1 so they match the corresponding address. Is this possible.

Ex)
A B
1234 any street
Detroit, MI 91777
1234 way street
Detroit, MI 58777
1234 ryan st
detroit, MI 99999

So I am trying to move the city state and zip to column B. I actually have a macros to delete empty cells so I could just run that on both columns after I shift the data.
Thanks!!

If you setup a macro, then replace it's code with

Please Login or Register  to view this content.

this should work.

Of course, save your work before this code destroys it.

hth
---