The function Vstack allows you to dynamically combine two or more tables into one.

Syntax:

=Vstack(table1, table2,…)

Table1. Any array, table or range of cells to be stacked

Table2. Any array, table or range of cells to be stacked

tip. convert your range of cells containing the desire data to tables with CTRL + T, before using Vstack