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