Question: how to copy and paste alternate columns 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.