如何在Google Sheets中自动将一行分割成不同的行？

function splitRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  var newValues = [];

  for (var i = 0; i < values.length; i++) {
    var row = values[i];
    var cells = row[0].split(","); // 按照逗号进行分割，可以根据需求修改分隔符

    for (var j = 0; j < cells.length; j++) {
      var newRow = [];
      newRow.push(cells[j]);
      newValues.push(newRow);
    }
  }

  var newRange = sheet.getRange(1, 1, newValues.length, 1);
  newRange.setValues(newValues);
}