any way to move cells automatically

[ewso]

I have a table with two columns that looks like this..

Jeff...Rita


Lara..Sam
Kirk..Barry


I want to be able to move the names from the second column over to the first column and down one row so that it looks like this..

Jeff
Rita
Lara
Sam
Kirk
Barry

I posted this question in the excel programming forum looking for a macro, but nobody answered me, so I guess nobody knows how to do it with a macro. Is there something I can do?

thanks for help!