Online PHP editor | refs for k8GFV

<?php $read = [ ['DATE' => '2018-01-30', 'company_id' => '1', 'Approved' => '10'], ['DATE' => '2018-01-30', 'company_id' => '2', 'Approved' => '5'], ['DATE' => '2018-01-31', 'company_id' => '1', 'Approved' => '10'], ]; $result = []; foreach ($read as $_row) { if (!isset($ref[$_row['DATE']])) { $ref[$_row['DATE']] = ['date' => $_row['DATE']]; $result[] =& $ref[$_row['DATE']]; } $ref[$_row['DATE']][$_row['company_id']] = $_row['Approved']; } var_export($result);