Moving cells

[lilgreen]

I know this will be easy for you. My data is consistent. A1 is the header, the spacing in the columns is the same. I want to move data in A4 to B3 then delete Row 4-6. Then do the same thing all the way down. So in essence I want the address to move up beside the church name. I threw in the delete part because I will need to do that anyway. I could even do that in a separate process. I understand formulas well not so good with macros and vlookups. If you have instructions I can follow them.

Name	Address Line 1
Beachhead Gatherings
918 Oakwood Dr Castle Rock CO
Colorado
Harvest Baptist Church
603 S Gilbert St Castle Rock CO
Colorado

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Moving cells
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.