Hi!

Enter this formula in cell A1 as an array using the key combo of
CTRL,SHIFT,ENTER:

=IF(ROWS($1:1)<=COUNTA(A$10:A$50),INDEX(A$10:A$50, SMALL(IF(A$10:A$50<"",(ROW(A$10:A$50)-ROW(A$10))+1),ROW(1:1))),"")

Copy across to K1 then down to K5.

Biff

"Jeremy N." wrote in message
...
For argument, I will simplify my range into A10:K50.

There will be anywhere from 1 to 5 values in each of these columns, but
not
successively. There will be several blank cells inbetween these nonblank
cells, which I need stacked neatly into the first five rows at the top of
the
worksheet.

Example:

(A10) - Apples
(A17) - Oranges
(A23) - Peaches
(A38) - Some other fruit of your choice...

(B14) - Toyota
(B21) - Honda
(B44) - Mercury
(B45) - Dodge
(B46) - Matchbox

These nonblank cells, amongst only blank cells, would need to be displayed
at the top of their respective columns as follows:

(A1) - Apples
(A2) - Oranges
(A3) - Peaches
(A4) - Some other fruit of your choice...

(B1) - Toyota
(B2) - Honda
(B3) - Mercury
(B4) - Dodge
(B5) - Matchbox

The cells A1:A5 would need to display the values in the 1st - 5th nonblank
cells, respectively, in the A columns. The cells of the first five rows
over
to column K will need to perform the same action for each of their
respective
columns. If the values in the source nonblank cells are changed, moved, or
deleted, these first five rows will need to reflect any such changes like
any
good Excel formula should.

Time is of the essence, so please be swift...
Thank you in advance.

Jeremy N.