Moderator..Please delete my post in the excel programming forum. Nobody knows how to do this with a macro over there so maybe I can get a way in this forum to do it without a macro. Thanks.

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


thanks for help!