Trying To Populate A Name Column

I am trying to update a name column in the following way: (I wrote a description, but I think this visual is easier to understand).

This is what I have:

name1 name2 address etc

Bob null 123 street

Sue null 123 street

Jack null ABC circle



This is what I want:

name1 name2 address etc

Bob Sue 123 street

Jack null ABC circle



I'm just trying to get 2 names on the same row if they have the same address and get rid of the spare row. Name2 is currently null. Seems simple enough but I don't know how to do it in SQL. I can do it in FoxPro, but that doesn't help me here.

Thanks for any ideas.