Data in each alternative cell

[arif]

Suppose i want to copy each cell data in an alternative cell by formula how can i do it

i have attached sample file where i have done it manually

now want to use formula for doing it autimatically

 

[Luke M]

If starting in an even row:
=IF(MOD(ROW(),2)=0,100,"")
If an odd row:
=IF(MOD(ROW(),2)=1,100,"")

 

[prasaddn]

Arif,
I guess you want formula want to copy from alternate cells, right?

to answer you need to share where you want this data to be pasted.

Regards,
Prasad DN