Online PHP editor | refs for 85EHX

<?php $csv = [ ['s1','n1','description 1', 'Helmets'], ['s1','n1','description 1a', 'Helmets'], ['s2','n1','description 2', 'Gloves'], ['s2','n1','description 2a', 'Gloves'], ]; $catMap = [ 'Helmets' => 30, 'Gloves' => 20, ]; $result = []; foreach($csv as $row){ //#1 trimming: $row = array_map('trim', $row); $sku = $row[0]; //#2 cat remapping assert(isset($catMap[$row[3]])); $row[3] = $catMap[$row[3]]; //combining if(isset($result[$sku])){ $result[$sku][2] .= ' ' . $row[2]; }else{ $result[$sku] = $row; } }; var_dump($result);