The function Hstack allows you to dynamically combine two or more tables or columns into one horizontal array.
Syntax:
=Hstack(table1, table2,…)
Table 1. Any table, array or range of cells to be stacked
Table 2, Any table, array or range of cells to be stack
tip. convert your range of cells containing the desire data to tables with CTRL + T, before using Hstack