Hi,

Is it possible to take every other row and move each of those up so to
be adjacent to the previous row?

Example:

A1
A2
A3
A4

Objective:

A1 B1(A2)
A3 B2(A4)

Thanks.

Mike Catalfamo


--
catalfamo1220
------------------------------------------------------------------------
catalfamo1220's Profile: http://www.excelforum.com/member.php...o&userid=29458
View this thread: http://www.excelforum.com/showthread...hreadid=495539

catalfamo1220 wrote:
Hi,

Is it possible to take every other row and move each of those up so to
be adjacent to the previous row?

Example:

A1
A2
A3
A4

Objective:

A1 B1(A2)
A3 B2(A4)

Thanks.

Mike Catalfamo


One way, if the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=ArrayReshape(A1:A4,2,2), array entered into the output location.

Alan Beban

Thanks Alen, could you just help me understand exactly what to do tha
the workbook from the link you gave me?

Thank

--
catalfamo122
-----------------------------------------------------------------------
catalfamo1220's Profile: http://www.excelforum.com/member.php...fo&userid=2945
View this thread: http://www.excelforum.com/showthread.php?threadid=49553

Bump - - - - - - (had to insert extra characters

--
catalfamo122
-----------------------------------------------------------------------
catalfamo1220's Profile: http://www.excelforum.com/member.php...fo&userid=2945
View this thread: http://www.excelforum.com/showthread.php?threadid=49553

Bump what? Unless you *quote* then most people have no idea what you're
bumping....

Tim


"catalfamo1220"
wrote in message
news:catalfamo1220.20lzkm_1135536001.8691@excelfor um-nospam.com...

Bump - - - - - - (had to insert extra characters)


--
catalfamo1220
------------------------------------------------------------------------
catalfamo1220's Profile:
http://www.excelforum.com/member.php...o&userid=29458
View this thread: http://www.excelforum.com/showthread...hreadid=495539