JSFiddle - React, Tailwind, and code Playground
JavaScript
var productsbycode = {};
var products = [];
var data = [
["PC01","Product 1","11"],
["PC01","Product 1","17"],
["PC02","Product 2","85"],
["PC02","Product 2","16"],
["PC03","Product 3","38"],
["PC03","Product 3","19"],
["PC04","Product 4","38"],
["PC04","Product 4","99"]
];
$.each(data, function (key, val) {
if(typeof productsbycode[val[0]] !== "object"){
productsbycode[val[0]] = {name: val[1], prices: [val[2]]}; } else{
productsbycode[val[0]].prices.push(val[2]);
}
});
$.each(productsbycode, function(key, val){
var price1 = val['prices'][0];
var price2 = val['prices'][1];
if(price1 < price2){
products.push([key, val['name'], price1, price2]);
} else{
products.push([key, val['name'], price2, price1]);
}
});
console.log(products);