Question: how to copy and paste from one column to another in excel?
Answer: Select the cells that contain the data or other attributes that you want to copy.
On the Home tab, click Copy .
Click the first cell in the area where you want to paste what you copied.
On the Home tab, click the arrow next to Paste, and then select Paste Special.
Select the options you want.