I need to merge duplicate rows in an array and concatenate cells in multiple columns.

Script to do this on a single column gotten here: google script sheet, merging rows duplicate in array

If run merrgRows on the Transaction column, I get

Which is what I want.

But I need to concatenate multiple columns, not just on Transaction.

Original script

function mergeRow (rows) {
    let newRows = []
    let matched = []
    
    for (var i = 0; i < rows.length; i  ) {
        
        if (!matched.includes(i)) {
            let a = rows[i]
            let nextIndex = i 1
            let matches = []
            
            for (var x = nextIndex; x < rows.length; x  ) {
                if (a[1] === rows[x][1] && a[2] === rows[x][2]) {
                    matches.push(x);
                }
            }
            
            let newRow = a,
                n = 3,
                lastItem = a[n];
            
            matches.forEach(index => {
                lastItem  = ':'   rows[index][n]
                matched.push(index)
            })
            
            newRow[n] = lastItem
            newRows.push(newRow)
        }
    }
    return newRows 
}

My attempt to generalize mergeRow

function mergeRow2 (rows) {
    let newRows = []
    let matched = []
    
    for (var i = 0; i < rows.length; i  ) {
        
        if (!matched.includes(i)) {
            let a = rows[i]      //iterating trough each row
            let nextIndex = i 1
            let matches = [] 
            for (var x = nextIndex; x < rows.length; x  ) {
                if (a[1] === rows[x][1] && a[2] === rows[x][2]) {
                    matches.push(x);
                }
            }

          let cols = [3,6]; 

          cols.forEach(function(n){  
            var newRow = a
            var lastItem = a[n]  // The Input values for the first part of the concatenation
            
              matches.forEach(index => {
                  lastItem  = '|'   rows[index][n] //The column values to be concatenated to lastItem
                  matched.push(index)
              })

            newRow[n] = lastItem //The OUTPUT Column
            newRows.push(newRow)
          })         
      }
    }
    return newRows
}

I get

What I need

How to concatenate multiple columns?

Google sheet with data https://docs.google.com/spreadsheets/d/11GOevQJXEQAvljesu46SYWD4Yvfi-FCLl39EtCdBBa0/edit?usp=sharing

CodePudding user response：

Try this (I generalized a bit more)

//mC1 1st column index to test for dups
//mC2 2nd column index to test for dups
//Array of column indices to concatenate when merging rows duplicates in array
function mergeRow2(rows,mC1,mC2, cols) {
    let newRows = [],
        matched = [],
        headers = rows[0];
    
    for (var i = 0; i < rows.length; i  ) {
        
        if (!matched.includes(i)) {
            let a         = rows[i],
                nextIndex = i 1,
                matches   = [];
            
            for (var x = nextIndex; x < rows.length; x  ) {
                if (a[mC1] === rows[x][mC1] && a[mC2] === rows[x][mC2]) {
                    matches.push(x);
                }
            }
            
            let newRow   = a,
                lastItem = [];

            for(var n=0; n<= cols.length-1; n  ) {
              matches.forEach(index => {
                lastItem = a[cols[n]]
                lastItem  = '|'   rows[index][cols[n]]
                matched.push(index)

                newRow[cols[n]] = lastItem
              })
            }
          
             newRows.push(newRow)  
        };
    }

    return newRows
}