Online PHP editor | refs for tYDua

<?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); $row = [ 'SKU' => $row[0], 'Product_Name' => $row[1], 'Description' => $row[2], 'Category_ID' => $row[3], ]; $sku = $row['SKU']; //#2 cat remapping assert(isset($catMap[$row['Category_ID']])); $row['Category_ID'] = $catMap[$row['Category_ID']]; //#3 combining if(isset($result[$sku])){ $result[$sku]['Description'] .= ' ' . $row['Description']; }else{ $result[$sku] = $row; } }; var_dump($result);