Question: how to copy data from one column to another column in excel using formula?
Answer: Enter a formula in the top cell.
Select the cell with the formula, and hover the mouse cursor over a small square at the lower right-hand corner of the cell, which is called the Fill handle. ... 
Hold and drag the fill handle down the column over the cells where you want to copy the formula.