macro to move cells
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
Is there a macro that I can use to do this?
thanks
|