![vstack sintax vstack sintax](https://cdn.educba.com/academy/wp-content/uploads/2020/09/NumPy-vstack-1.5-300x218.png)
Where cell values in the first row of each Range/Array match the cell values in the first row of the first range/array the columns are placed in the output array in that matched column. Preface the non-array argument with a comma to make it vthe first HDR.VSTACK item. Note: A non-array argument given for the first argument to HDR.VSTACK will be treated as a fill value. Use zero if you want to append differently-sized numeric arrays or arrays with some different header cells and pass the output to an aggregating function such as SUM() or a single-cell array formula. When the Arrays or ranges to be appended do not have matching column headers the gaps will be filled with the Fill character. HDR.VSTACK (, Arg1, Arg2, …, Arg29)Ī cell or character or digit to be used to fill unused cells in the output array, for example 0.0 or “”. HDR.VSTACK is a multi-threaded, non-volatile array function. Up to 29 Range /Array arguments can be appended below one another row wise.Įach column with a matching header is stacked below it’s matching column.Ĭolumns in subsequent arrays/ranges where column headers do not match the first array/range column header are filled with Fill characters, for example #N/A (default) or 0.0 or "". Matches cells in the first header row of the array/range to header row cells from multiple arrays or ranges to create an output array with a single header row. Navigation: FXLV4SpeedTools > Array shaping functions >