要使用App Script进行数据转置和追加行，您可以使用以下代码示例：

function transposeAndAppendRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var transposedData = transposeData(data);
  var lastRow = sheet.getLastRow();
  
  // 追加转置后的数据
  sheet.getRange(lastRow + 1, 1, transposedData.length, transposedData[0].length).setValues(transposedData);
}

function transposeData(data) {
  var transposedData = [];
  
  for (var i = 0; i < data[0].length; i++) {
    transposedData[i] = [];
    for (var j = 0; j < data.length; j++) {
      transposedData[i][j] = data[j][i];
    }
  }
  
  return transposedData;
}

使用上述代码，将会在当前活动表格的下一行追加转置后的数据。