Working with arrays, or adjacent cell ranges, in Microsoft Excel can be challenging at times. If you’d like to combine, reshape, or resize an array, you can choose from a collection of functions that can cover many situations.
Note: These 11 functions are new to Excel as of August 2022. They’re rolling out to Excel users over time beginning with Office Insiders.
Combine Arrays
Combining data in a spreadsheet can be difficult. With the VSTACK and HSTACK functions, you can stack arrays vertically and horizontally.
RELATED: How to Combine Data From Spreadsheets in Microsoft Excel
The syntax for each function is the same as VSTACK(array1, array2,…) and HSTACK(array1, array2,…) with only one required array and others optional.
To combine the arrays in cells B2 through F3 and H2 through L3 vertically, use this formula for the VSTACK function:
=VSTACK(B2:F3,H2:L3)
To combine those same arrays horizontally instead, use this formula for the HSTACK function:
=HSTACK(B2:F3,H2:L3)
Reshape Arrays
If it’s not combining arrays that you…
Read Full Article Source
