Online PHP editor | output for ag3To

<?php $Arr1=Array ( 0 => Array ( "id" => "4123", "test_number" => "1", "sat_total" => "1050" ), 1 => Array ( "id" => "4123", "test_number" => "2", "sat_total" => "1130" ), 2 => Array ( "id" => "4123", "test_number" => "3", "sat_total" => "1120" ), 3 => Array ( "id" => "5555", "test_number" => "1", "sat_total" => "1130" ), 4 => Array ( "id" => "5555", "test_number" => "2", "sat_total" => "1160" ) ); $ids = array_column($Arr1, "id"); $sat = array_column($Arr1, "sat_total"); Foreach(array_unique($ids) as $id){ $new[$id] = ["id" => $id]; $tmp = array_values(array_intersect_key($sat,array_intersect_key($Arr1, array_intersect($ids, [$id])))); For($i=1;$i<=count($tmp);$i++) $new[$id]["Score" . $i] = $tmp[$i-1]; } Var_dump($new);