Question: how to copy and paste part of a column 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.