<?php $data = [ [ 'Access ID' => 12345, 'Registration Date' => '2018-02-27', 'First Name' => 'Damian', 'Last Name' => 'Martin', 'Flying Tour' => '' ], [ 'Access ID' => 12345, 'Registration Date' => '2018-02-27', 'First Name' => 'Damian', 'Last Name' => 'Martin', 'Flying Tour' => 'Yes going' ], [ 'Access ID' => 789456, 'Registration Date' => '2018-03-27', 'First Name' => 'Ricky', 'Last Name' => 'Smith', 'Flying Tour' => '' ], [ 'Access ID' => 789456, 'Registration Date' => '2018-03-27', 'First Name' => 'Ricky', 'Last Name' => 'Smith', 'Flying Tour' => 'Two way going', ], [ 'Access ID' => 987654, 'Registration Date' => '2018-04-27', 'First Name' => 'Darron', 'Last Name' => 'Butt', 'Flying Tour' => '' ] ]; $result = []; foreach ($data as $row) { if (empty($result[$row['Access ID']]['Flying Tour'])) { $result[$row['Access ID']] = $row; } } var_export(array_values($result));
You have javascript disabled. You will not be able to edit any code.