Merge cells having same values bottom down

Question

I have a google sheet where i need to merge the cells if the values are repeating

The expected is to merge the cell from A1 to A4 and have a single value A in it.

I have tried with,

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var range = sheet.getActiveRange();
//var values = range.getValues();
var numCols = values[0].length;

    values = [
        ["A", "B", "C", "D", "E"],
        ["A", "B", "S", "D", "E"],
        ["A", "D", "C", "D", "E"],
        ["A", "B", "C", "D", "K"],
        ["c", "B", "W", "D", "K"],
        ["A", "B", "C", "D", "E"],
    ]

    for (var j = 0; j < numCols; j++) {
        var placer = '';
        for (var i = 0; i < values.length - 1; i++) {
            if (values[i][j] == values[i + 1][j])
                range.getCell(i + 2, j + 1).setValue('');
        }
    }

Answer 1

• You want to merge cells vertically when the cells have the same values to the vertical direction.

• You want to achieve the following situation.

• Input

• Output

If my understanding is correct, how about this modification? Please think of this as just one of several answers.

The flow of my sample script is as follows.

1. Transpose the values.
2. Start and end addresses for merging cells are retrieved from the transposed values.
3. Merge cells using the retrieved addresses.

Sample script:

// Retrieve values from the active sheet.
var sheet = SpreadsheetApp.getActiveSheet();
var values = sheet.getDataRange().getValues();

// Transpose values.
var res1 = values[0].map(function(_, i) {return values.map(function(e) {return e[i]})});

// Merge cells.
res1.forEach(function(col, i) {
  var temp = {};
  col.forEach(function(row, j) {
    if (row === col[j + 1] && !(row in temp)) {
      temp[row] = j;
    } else if (row != col[j + 1] && row in temp) {
      sheet.getRange(temp[row] + 1, i + 1, (j - temp[row]) + 1, 1).merge();
      temp = {};
    }
  });
});

Note:

• This is a simple sample script. So please modify this for your situation.

References:

• merge()
• forEach()

If I misunderstood your question and this was not the result you want, I apologize.

Edit:

This is the answer for the additional question.

Usage:

1. Manually select cells "A2:C6" on "Sheet1".
2. Run the script.

Script:

// Retrieve values from the active sheet.
var range = SpreadsheetApp.getSelection().getActiveRange();
var sheet = range.getSheet();
var values = range.getValues();

// Transpose values.
var res1 = values[0].map(function(_, i) {return values.map(function(e) {return e[i]})});

// Offset
var r = range.getRow() - 1;
var c = range.getColumn() - 1;

// Merge cells.
res1.forEach(function(col, i) {
  var temp = {};
  col.forEach(function(row, j) {
    if (row === col[j + 1] && !(row in temp) && row != "") {
      temp[row] = j;
    } else if (row != col[j + 1] && row in temp) {
      sheet.getRange(r + temp[row] + 1, c + i + 1, (j - temp[row]) + 1, 1).merge();
      temp = {};
    }
  });
});

Result:

Before:

After: