importrange可以将所有内容移动到单个列中吗

=TRANSPOSE(IMPORT_RANGE("source_spreadsheet_id", "source_sheet_name!A1:B10"))

function importDataToSingleColumn() {
  var sourceSpreadsheet = SpreadsheetApp.openById('source_spreadsheet_id');
  var sourceSheet = sourceSpreadsheet.getSheetByName('source_sheet_name');
  var sourceRange = sourceSheet.getRange('A1:B10'); // 调整范围以匹配你的数据
  var sourceValues = sourceRange.getValues();

  var targetSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var targetSheet = targetSpreadsheet.getSheetByName('target_sheet_name');
  var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1, sourceValues.length, sourceValues[0].length);

  // 将数据转置为列
  var transposedValues = sourceValues[0].map((_, colIndex) => sourceValues.map(row => row[colIndex]));
  targetRange.setValues(transposedValues);
}