google sheets join two ranges code example

Example: google sheets combine ranges

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