Online PHP editor | output for 7CFRf

<?php $data = array( 0 => array('id' => 8, 'month' => 1, 'cost' => 12500), 1 => array('id' => 8, 'month' => 2, 'cost' => 14200), 2 => array('id' => 9, 'month' => 1, 'cost' => 23000), 3 => array('id' => 9, 'month' => 2, 'cost' => 18000), ); $by_id = []; foreach($data as $x) { $by_id[$x['id']][$x['month']] = $x['cost']; // e.g. $by_id[8][2] = 14200; } $html = []; $html[] = '<table>'; $html[] = '<tr><th>ID</th><th>Jan</th><th>Feb</th></tr>'; foreach($by_id as $id => $months) { $html[] = '<tr>'; $html[] = "<td>{$id}</td>"; foreach($months as $month => $cost) { $html[] = "<td>{$cost}</td>"; } $html[] = '</tr>'; } $html[] = '</table>'; echo implode("\n", $html);