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

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

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 copypaste specialvalues
or elsewhere
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ad" wrote in message
...
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

thanks duke & max!

"Max" wrote:

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 copypaste specialvalues
or elsewhere
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ad" wrote in message
...
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

You're welcome!
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ad" wrote in message
...
thanks duke & max!