Thread: Moving Rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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