Online PHP editor | refs for mdA0W

<?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, "scores" => array_values(array_intersect_key($sat,array_intersect_key($Arr1, array_intersect($ids, [$id]))))]; } var_dump($new);