Data manipulation between cells or columns

Hi,
I'm certainly not a power Excel user and there may be a simpler way to do what I need to do, but here goes. I have to columns, one with cell phone numbers and one with home phone number. What I need to do is have one column with a cell number in if it existed, and if not, then put in the home phone number. I got to the point of being able to use a formula to determine if the cell was empty or not, but I can't figure out a way to say if it is empty, then move or copy the data from the cell next it in the same row.
I did see in another post that Excel can't use formulas to move or copy data and that VB script would be needed to do that. Is that correct?

Columns.PNG

Not sure if my image was inserted or not, but if it did, You can see that column E has 2, 3, and 4 populated with a "home number" while column F has those rows empty. I need to get those home phone numbers into the empty rows while leaving the cell numbers as they are when they are populated. The spreadsheet is nearly 1,000 lines long so I really would prefer an automated process for this if possible.

Thanks for any help,

I don't think that will work. If there are rows that have both a cell phone number and a home number, this process would over write the cell phone I believe and I want to leave those cell phone numbers as they are.

Hmm, I cut and pasted the formula in and it does indeed overwrite the cell number. And it's simply taking the phone number and incrementing the last digit upward by one for every row. (See below). What am I doing wrong?Attachment 783786

I'm sorry, all that formula does is empty the cells as I drag it down. Perhaps I'm not understanding something basic that other are assuming I would know. Attachment 783788

Try this. The quick reply attaches rather than inserts it would seem.
Columns01.PNG

You are correct, I did place it in G1. However when I put in G2, (without the G2 in the front), I get the same blank cells.

Column02.PNG

I apologize if I didn't articulate it well. Before I ran the formula down the column, some were blank other had numbers. The premise is, that I have two columns and the automatic calling system can only one without a huge amount of effort. If they have a cell number, that is the number we want to use. But if we have only a home phone number and not a cell number, then I need to move the home phone number into that empty space. If a cell number already occupies the cell, i need to be left as it is.

Not getting the desired results with that.
Attachment 783809

However, =IF(F2>0,F2,E2) is doing the trick. It puts in in a different column but I can work with that.

Thanks for you help.