Google Apps脚本复制一个工作表中的列，将其转置，然后粘贴到另一个工作表中

function copyAndTransposeColumn() {
  var sourceSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("源工作表名称");
  var targetSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("目标工作表名称");
  
  var sourceRange = sourceSheet.getRange("源列范围");
  var sourceValues = sourceRange.getValues();
  
  var transposedValues = transposeArray(sourceValues);
  
  var targetRange = targetSheet.getRange("目标起始单元格");
  targetRange.offset(0, 0, transposedValues.length, transposedValues[0].length).setValues(transposedValues);
}

function transposeArray(array) {
  return Object.keys(array[0]).map(function (column) {
    return array.map(function (row) {
      return row[column];
    });
  });
}