potentially in B1 enter =if(A1<"",A2,"")
copy and paste down.
copy column B and paste special values
This assumes there is a blank line between groupings.


"Outlook, eh?" wrote:

Frustratingly enough a user created a column like:

A
Bill Hicks
3261 Austin Street

Daniel Johnston
1717 Yip Jump Way

I would like to move only addresses to column B, thus it would be:

A B
Bill Hicks 3261 Austin Street

Any help would be most appreciated!
-B