View Single Post
 
Old 10-05-2017, 12:05 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default 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