如何将重复的单元格与google应用脚本合并在一起？

function mergeDuplicates() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var mergedData = [];
  
  for (var i = 0; i < data.length; i++) {
    var row = data[i];
    var mergedRow = [];
    
    for (var j = 0; j < row.length; j++) {
      var cell = row[j];
      
      if (cell !== "") {
        mergedRow.push(cell);
      } else {
        var previousCell = mergedRow[mergedRow.length - 1];
        
        if (previousCell !== undefined && previousCell === "") {
          mergedRow.push("");
        }
      }
    }
    
    mergedData.push(mergedRow);
  }
  
  sheet.clearContents();
  sheet.getRange(1, 1, mergedData.length, mergedData[0].length).setValues(mergedData);
}