HSTACK function/text/scalc/01/func_hstack.xhpHSTACK function
HSTACK
Appends arrays horizontally to create a larger array.=HSTACK(Array [; Array_1 [; Array_2;[...]]]) Array: The first array to be returned in a new array.Array_1; Array_2; ...: (optional) the arrays to append sequentially after the previous array.And the second array as:The formula {=HSTACK(A1:E3;N15:O19)} returns the array below, with data of array N15:O19 on the right of the data of array A1:E3, and extra cells filled with #N/A error: