$result = array(); $quartalId = array(); foreach($query as $key) { if(array_key_exists($key['jahr'], $result)) { $quartalId[$key['quartalId']] = $key['gewicht']; $result[$key['jahr']] = $quartalId; } else { $result[$key['jahr']] = $key['jahr']; $quartalId[$key['quartalId']] = $key['gewicht']; $result[$key['jahr']] = $quartalId; } }