google sheets join ranges into two columns code example

Example: google sheets combine ranges

-- Google Sheets: Combine ranges
={sheet1!a:a; sheet2!a:a}