Moving every other row
 

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

Moving every other row
 

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

Moving every other row
 

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

Moving every other row
 

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

Moving every other row
 

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