moving alternating rows to a column with the order staying the sam

[Guest]

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

 

[Max]

Another way to try ..

Assuming data is in col A, from row1 down,

Put in B1:
=OFFSET($A$1,ROWS($A$1:A1)*2-2+COLUMNS($A$1:A1)-1,)

Copy across to C1, fill down until zeros appear, signalling exhaustion of
data from col A
(For your 11k + rows, fill down till C5500 thereabouts <g>)

Freeze the values in cols B and C with an in-situ copy>paste special>values
or elsewhere

 

[Guest]

thanks duke & max!

Another way to try ..

Assuming data is in col A, from row1 down,

Put in B1:
=OFFSET($A$1,ROWS($A$1:A1)*2-2+COLUMNS($A$1:A1)-1,)

Copy across to C1, fill down until zeros appear, signalling exhaustion of
data from col A
(For your 11k + rows, fill down till C5500 thereabouts <g>)

Freeze the values in cols B and C with an in-situ copy>paste special>values
or elsewhere

 

[Max]

You're welcome!