Copying Every Other Cell

[Brabed]

How would I copy every other cell in a column to another column?

Example- I want to only Copy A:1,A:3,A:5,A:7, etc to another column....

Thanks in advance.

 

[Krishnakumar]

Hi,

Try,

=INDEX($A$1:$A$25,ROWS($1:1)*2-2+1)

HTH

 

[Brabed]

Actually, I want to revise my original question... I want to form two columns of data by copying data which alternates between two existing columns of data. Like this:

A B
54 35
85 47
65 85
23 56

becomes.....

C D
54 35
47 85
65 85
56 23

..in essence, I want every other row to swap data between columns.

 

[Joe4]

Enter these formulas in the columns:
Cell C1: =IF(MOD(ROW(),2)=1,A1,B1)
Cell D1: =IF(MOD(ROW(),2)=1,B1,A1)
and copy down for all rows.