one way

In B1 place the formula

=IF(MOD(ROW(),2)=1,A2,"")

Copy it all the way to the bottom - you should get alternating rows where
the switch # lines up next to the correct address#

If so, copy the entire column B, the EditPaste Special Values

If you need to keep all of these in the original order, insert a helper
column & fill it with a series of ascending numbers.

Then sort the entire bit on column B & delete all the rows where column B = ""

If needed, resort on the helper column to return the list to the original
order




"ad" wrote:

I am working on a sheet that has more 11000+ rows. I need to move alternating
rows to a column without having to do it manually. However, currently A1
correspondes with A2, A3 with A4, etc. How can I move it from:

address1
switch#1
address2
switch#2

to:

address 1 switch#1
address 2 switch#2
address 3 switch#3