How to union ranges in google spreadsheets December 30, 2022 by Tarik Just use: ={sheet1!a:a; sheet2!a:a}