Moving Rows
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.
--
Regards,
Tom Ogilvy
"Ken" wrote in message
om...
How can I move alternate rows in an Excel table up one and over one?
For example I want:
a
b
c
d
e
f
to become:
ab
cd
ef
Thanks.
Ken
|