Move text to every other cell

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

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


<[email protected]> wrote in message
news:O%[email protected]...
> 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,
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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> <[email protected]> wrote in message
> news:O%[email protected]...
>> 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
>>
>>
>
>

Hi,

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

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

Regards,
KL


<[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>> <[email protected]> wrote in message
>> news:O%[email protected]...
>>> 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
>>>
>>>
>>
>>
>
>

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

<[email protected]> wrote in message
news:O%[email protected]...
> 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
>
>