Online PHP editor | output for 1IXDb

<?php $array = [ [ 'name' => 'Edward Foo', 'desc_topic' => ['Apple', 'Banana', 'Orange'], 'qtd_posts' => [10, 20, 50 ], ], [ 'name' => 'Michael Max', 'desc_topic' => ['Apple', 'Banana', 'Orange'], 'qtd_posts' => [10, 10, 10 ], ], [ 'name' => 'Edward Foo', 'desc_topic' => ['Apple', 'Banana', 'Orange'], 'qtd_posts' => [5, 10, 50 ], ], [ 'name' => 'Michael Max', 'desc_topic' => ['Apple', 'Banana', 'Lemon'], 'qtd_posts' => [8, 8, 55 ], ], ]; $result = []; foreach ($array as $row) { extract($row); if (!isset($result[$name])) { $result[$name] = $row; } else { foreach ($desc_topic as $i => $topic) { $index = array_search($topic, $result[$name]['desc_topic']); if ($index === false) { // create new column in both subarrays $result[$name]['desc_topic'][] = $topic; $result[$name]['qtd_posts'][] = $qtd_posts[$i]; } else { // sum preexisting value with new value in on same topic $result[$name]['qtd_posts'][$index] += $qtd_posts[$i]; } } } } var_export(array_values($result));