HSTACK 
HSTACK(array1 [,array2] [..]) 
Returns the array after putting multiple arrays next to 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 columns, they are placed next to each other, left to right. Example 1. * If the arrays are single rows, they are placed next to each other in a single row. 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 VSTACK function to return the array array after putting multiple arrays on top of 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:C2" and "D1:D2" as one array. 2  What is the combination of the range "C1:D1" and "C2:D2" as one array. 3  What is the combination of the range "C1:C2" and "E1:E2" as one array. 4  What is the combination of the range "C1:C2", "D1:D2" and "E1:E2" as one array. 5  What is the combination of the range "C1:C2" and "D1:E2" as one array. 6  What is the combination of the range "C1:F1" and "C2:F2" as one array. 7  What is the combination of the range "C1:C2" and "D1" 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 horizontal array. 9  What is the combination of the range "C1:C2" and "D1" 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 "D1:D2" as one array. Notice the semicolon in the array. This is interpreted as a 2x2 (2 row, 2 column) array the same size as "D1:D2" 11  What is the combination of the array {"a","b"} and "D1:D2" as one array. Notice the comma in the array. This is interpreted as a 1x2 (1 row, 2 column) array a different size to "D1:D2" 
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top