Appends arrays horizontally and in sequence to return a larger array.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
HSTACK(array1, [array2], ...)The HSTACK function combines multiple arrays or ranges by adding them side-by-side. It is particularly useful for merging data sets that share the same number of rows but have different columns.
=HSTACK({1,2}, {3,4})결과: {1, 2, 3, 4}
Combines two horizontal arrays into a single row of four elements.
The function will return a #N/A error for the missing cells in the shorter arrays.