Some time ago, I asked how to move rows so that

a
b
c
d
e
f

became

ab
cd
ef

I've reposted the solution below.

Now I want to have

a
b
c
d
e
f
g
h
etc.

become (each letter in a column)

abcd
efgh

I've tried changing the numbers in the following solution to the
original solution without success. How can I move four rows as above?
Thanks.

Original solution:

assume a is in A1
in B1 put in

=if(mod(row(),2)=1,A2,na())
then drag fill down the column

Now select the column, and do Edit=Copy, then immediately do
Edit=Paste
Special and select Values

The (column still selected) do Edit=Goto=Special and select constants
and
(uncheck all but errors) errors, then do delete and select entirerow.

Ken