Google Apps Script: Set Value Of Blank Cell
How can you easily check if a Google Sheet cell has a value, and if it doesn’t to set a default value when assigning it to a variable in Google App Script?
Spreadsheets
How To Merge Two Columns Into One (Google Sheets)
If you need to join two columns of unknown height together then follow this step-by-step illustrated guide.