VSTACK |
VSTACK(array1 [,array2] [..]) |
Returns the array after putting multiple arrays on top of each other. |
array1 | The first array to be appended. |
array2 | (Optional) The second array to be appended. |
REMARKS |
* This function was added in Microsoft 365. * This function can create a Dynamic Array Formula. * This function can be used to combine data from multiple worksheets. * If the arrays are single rows, they are stacked on top of each other. Example 1. * If the arrays are single columns, they are stacked in a single column. Example 2. * If the arrays are not the same size, they are padded with #N/A. * You can have a maximum of 254 arguments. * You can use the HSTACK function to return the array after putting multiple arrays next to each other. * You can use the TOCOL function to return the array transformed into a single column. * You can use the TOROW function to return the array transformed into a single row. * This function was first released in March 2022. * For the Microsoft documentation refer to support.microsoft.com |
|
1 - What is the combination of the range "C1:D1" and "C2:D2" as one array. 2 - What is the combination of the range "C1:C2" and "D1:D2" as one array. 3 - What is the combination of the range "C1:D1" and "C3:D3" as one array. 4 - What is the combination of the range "C1:D1", "C2:D2" and "C3:D3" as one array. 5 - What is the combination of the range "C1:D1" and "C2:D3" as one array. 6 - What is the combination of the range "C1:C3" and "D1:D3" as one array. 7 - What is the combination of the range "C1:C4" and "D1:D4" as one array. 8 - What is the combination of the range "C4", "E3" and "F1" as one array. These individual values are placed in a vertical array. 9 - What is the combination of the range "C1:D1" and "C2" as one array. Notice the second array is a different size so #N/A is used as padding. 10 - What is the combination of the array {"a","b"} and "C1:D1" as one array. Notice the comma in the array. This is interpreted as a 1x2 (1 row, 2 column) array the same size as "C1:D1". 11 - What is the combination of the array {"a" ; "b"} and "C1:D1" as one array. Notice the semi-colon in the array. This is interpreted as a 2x2 (2 row, 2 column) array a different size to "C1:D1". |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top