union of two columns in sheets code example

Example: google sheets combine ranges

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