The dsMergeV is a special spreadsheet function supplied by Deriscope that creates a data array by merging the contents of up to 6 ranges in vertical fashion.

Visit the
Deriscope Excel Functions for practical tips on how to generate demos of this and the other Deriscope functions on the spreadsheet.

It takes at least 2 arguments with additional optional arguments up to a maximum total of 6 and has the following form:

=dsMergeV( arg1, arg2, [arg3], …, [arg6] )

Each supplied argument must be some range.
All ranges must have the same width (i.e. number of columns) so that they can be collated from top to bottom.
The data of the first range arg1 will be the topmost section of the produced merged array of data.