I get a table with the content containing several similar products but with different lines and codes, another important information is that sometimes it already comes from my client grouped by color. I would like to make a script or formula if possible, where I would group these similar product lines into just one, concatenating the data and contents of similar lines, for later I get that worksheet and use it in indesign .
Sample document: link
I was able to do something similar but only for 2 lines with a formula in Google Spreadsheets. Example:
=IF(A1>=A2;if(H1=H2;concatenate("0";B1;" ";C1;" /** ";"0";B2;" ";C2)))
Note: with this code I can not compare more than one line, and when there is no other similar product, comparison it also does not work returning null .
I think the solution depends on Javascript. Please help me.