MATRIX
Concatenate disjointed arrays in Excel column (or row)-wise into a matrix
Last updated
Concatenate disjointed arrays in Excel column (or row)-wise into a matrix
Last updated
Microsoft Excel does not provide a natural way to work with concatenating numerical arrays / vectors. The only natural way to do this in Microsoft Excel is to input or display vectors adjacent to another within a worksheet.
This restriction can force copying and replicating vectors into new or existing sheets when constructing more complex workbooks that require references to matrix's constituents in different columns (or rows).
The MATRIX function in Excel Lab allows you to concatenate arrays intuitively and can be used nested within other Microsoft Excel or Excel Lab functions.
Argument
Description
v1,v2,...,vN
Column-vectors, row-vectors, or matrices.
isRow
Optional. Logical flag (TRUE or FALSE) to indicated whether you would like to concatenate the input vectors/matrices row-wise. Defaults to false (column-wise concatenation).