在Google Sheets脚本中将数据从行转置到列

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

  for (var i = 0; i < values[0].length; i++) {
    transposedData[i] = [];
    for (var j = 0; j < values.length; j++) {
      transposedData[i][j] = values[j][i];
    }
  }

  var transposedRange = sheet.getRange(1, range.getLastColumn() + 2, transposedData.length, transposedData[0].length);
  transposedRange.setValues(transposedData);
}