Question: how to copy and paste every other column in excel?
Answer: Select a blank cell (here I select cell D2) in the new range you need to paste the copied data into, then enter formula =MOD(ROW(A1),2).
Keep selecting cell D2, drag the Fill Handle down to the column cells. ... 
Then select cell D1, click Data > Filter to enable the Filter function.