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 copy>paste special>values
or elsewhere
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"ad" <ad@discussions.microsoft.com> wrote in message
news:C9605C08-6948-42E3-9548-47978A0EA885@microsoft.com...
> 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 copy>paste special>values
> or elsewhere
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "ad" <ad@discussions.microsoft.com> wrote in message
> news:C9605C08-6948-42E3-9548-47978A0EA885@microsoft.com...
> > 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 <at>yahoo<dot>com
----
"ad" <ad@discussions.microsoft.com> wrote in message
news:CB75D237-3217-4E6C-8FD4-07BFB425044A@microsoft.com...
> thanks duke & max!