Online PHP editor | refs for 0k40Q

<?php $data = array( array( "pages_coded" => "5", "type_of_request" => "Collector Tweak", "userfullname" => "Sam", ), array( "pages_coded" => "5", "type_of_request" => "Collector Code", "userfullname" => "John", ), array( "pages_coded" => "42", "type_of_request" => "Collector Tweak", "userfullname" => "John", ), array( "pages_coded" => "37", "type_of_request" => "Clinical Tweak", "userfullname" => "Dona", ), array( "pages_coded" => "35", "type_of_request" => "Collector Code", "userfullname" => "Dona", ), array( "pages_coded" => "7", "type_of_request" => "Clinical Code", "userfullname" => "Ricky", ), array( "pages_coded" => "50", "type_of_request" => "Clinical Tweak", "userfullname" => "Ricky", ), array( "pages_coded" => "4", "type_of_request" => "Collector Code", "userfullname" => "Ricky", ), array( "pages_coded" => "17", "type_of_request" => "Collector Tweak", "userfullname" => "Ricky", ) ); $output = array(); foreach ($data as $row) { $output[$row['userfullname']][$row['type_of_request']] = $row['pages_coded']; } $categories = array( 'Clinical Code' => 0, 'Clinical Tweak' => 0, 'Collector Code' => 0, 'Collector Tweak' => 0, ); foreach ($output as &$outputItem) { $outputItem = array_merge($categories, $outputItem); } echo "<pre>"; print_r($output);