Untitled

function fillEmptyCellsInAllColumns() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();

  for (var i = 1; i < values.length; i++) {
    for (var j = 0; j < values[i].length; j++) {  // ตรวจสอบทุกคอลัมน์ในแถว
      if (values[i][j] === "" && values[i-1][j] !== "" && values[i-1][j] !== 0) {
        values[i][j] = values[i-1][j];
      }
    }
  }

  range.setValues(values);
}