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.