Move text to every other cell

[Guest]

Hello.
My problem is that I am trying to pull date from every other row in
column K to every other row in column J. For example below is my current
data

Column J Column K
0
16
18
12
29
105
100
79


Desired results

Column J
0
16
18
12
29
105
100
79

I have used something like the following before to copy data in every other
row except that this will delete the data that I need to keep in column "J"

=IF(MOD(ROW()-1,2)=0,OFFSET($A$1,INT((ROW()-1)/2),0),"")


Any help or suggestions are much appreciated.


Judd

 

[KL]

Hi,

Try this:

1) Select the whole used range of the column J (including the first empty
cell) from top down
2) Go to the menu Edit>GoTo
3) Press the 'Special' button
4) Choose the 'Blanks' option
5) Press 'OK'
6) On the formula bar write =K1 (where 1 is the row number of the first
empty cell in column J)
7) Hold 'Ctrl' key and press 'Enter'
8) Copy the J column and PasteSpecial Values only.
9) Delete column K

Regards,
KL

 

[Guest]

KL,
Thanks for the suggestion. This works great except that I do not have
any blank cells in Column "J". If I could figure out a way to make every
other cell blank in column "J" then this would be perfect. I am trying to
replace every other cell in column "J" with data from column "K".


Judd

 

[KL]

Hi,

In cell [L1] enter the following formula and copy it down:

=IF(MOD(ROW(),2),K1,J1)

Regards,
KL

 

[Ron Coderre]

If Col K contains blanks, try this:

Select the cells in Col K (including the blanks).
-->In your example: From the zero through the cell containing 100

Edit>Copy

Then, select the top cell in Col J (the cell above 16 in your example)

Edit>PasteSpecial>Skip Blanks....Press Enter.

Does that help?

Regards,
Ron