In Sql there is Union Function to select and convert different tables into 1 version table
in my case
i am using google sheet as my database
i have 3 options to choose
- dont make it different sheets, just make it 1
- create a new sheet and using query union there, then make it a new table in appsheet
- appsheet can handle selection of 2 or more tables.
the easiest option here to chose is no 3.
thank you very much