Question: how to copy data from one column to another in excel using formula?
Answer: Click the cell with the formula to select it.
Press Ctrl + C to copy the formula.
Select a cell or a range of cells where you want to paste the formula (to select non-adjacent ranges, press and hold the Ctrl key).
Press Ctrl + V to paste the formula.