Moving Data

[stephen]

Is there any way to move mutliple cells from one column to
another column without having to grab each individual
cell. i.e. I want to move every forth cell in my A
column (A1,A5,A9,A13 etc.) and place them into my B column
(B1,B5,B9,B13 etc.)

I'm dealing with over 2000 rows and it would take me too
much time to do each individually.
Thanks.

 

[AndyB]

stephen

Try this in B1 and fill down
=IF((ROW()+3)/4=INT((ROW()+3)/4),A1,"")
You may want to past values afterwards

HTH
Andy

 

[Alain CROS]

Hi

Put this in B1 and fill down
=IF(MOD(ROW(A1)+3,4),"",A1)

Alain CROS.