Pretty close!

The only "problem" I see is the hardcoded 5's.

If data is added or deleted (as the OP said was possible) the hardcoding
isn't dynamic. I used a helper cell that returned the max count of entries
in any one column and referenced that cell in place of the hardcoded 5's but
that failed. That returned only the very first entry in the first column and
then everything else was either a #DIV/0! or a #VALUE!.

Biff

"Domenic" wrote in message
...
Here's a formula solution...

M10, copied down:

=INDEX(T(OFFSET($A$10:$A$50,ROW($A$10:$A$50)-ROW($A$10),INT((ROW()-ROW($M
$10))/5),1)),SMALL(IF(T(OFFSET($A$10:$A$50,ROW($A$10:$A$ 50)-ROW($A$10),IN
T((ROW()-ROW($M$10))/5),1))<"",ROW($A$10:$A$50)-ROW($A$10)+1),MOD(ROW()-
ROW($M$10),5)+1))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Note that you'll
get #NUM! error values when there are less than five values available
for a column. You can use conditional formatting to hide these errors.

Hope this helps!

In article ,
Jeremy N. wrote:

Due to some complications with the layout, I've been forced to move the
target formula cells to a lone column to the right of the source range.

The range, in discussion, will still exist at A10:K50. To the right of
this
range, I have blocked out 10 groups of 5 cells each, stacked in column M.
The
blocking will separate the results of the formula I need, which will
still
give me up to 5 values from each of the columns of the source range.

For example, the source range, as befo

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

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

Instead of appearing at the top of the worksheet, in the corresponding
rows,
these nonblank cells, still amongst only blank cells, will now need to be
displayed
to the right of the source range, as follows:

(M10) - Apples
(M11) - Oranges
(M12) - Peaches
(M13) - Some other fruit of your choice...

(M15) - Toyota
(M16) - Honda
(M17) - Mercury
(M18) - Dodge
(M19) - Matchbox

Notice the break between M13 and M15, where no 5th value from column A in
the source range would have been found; If a 5th value were added later,
the
cell M14 would be reserved for it. The results from the second column (B)
will appear in the next block of 5, directly below the results for column
A.
This will continue downward until column K has been accounted for.

In the event that the range is expanded, or the number of values returned
is
needed to increase or decrease, I need to know how the necessary formula
will
allow changes of that kind.

Thanks to Biff for his time. I wish I would've caught my mistake before
you
spent your time at this whole dilemma.
Again, thanks in advance to whoever can lend me their insight.

Jeremy N.