ToXa04

function order_merge_str() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var myRange = sheet.getActiveRange();
myRange.setBorder(true, true, true, true, null, null, '#000000', SpreadsheetApp.BorderStyle.SOLID);
var end_str = myRange.getLastRow();
var num_str = myRange.getNumRows()
var str0 = end_str - num_str + 1;
var end_col = myRange.getLastColumn();
var col0 = end_col - myRange.getNumColumns() + 1;
Logger.log(end_str)
Logger.log(str0)
Logger.log(end_col)
Logger.log(col0)
for (var i = col0; i <= end_col; i++) {
if (i != 4) {
sheet.getRange(str0, i,num_str).activate()
.mergeVertically();
}
}
}