Группируйте строки двумерного массива по двум столбцам и перезаписывайте бесполезные ассоциативные элементы в каждой гру ⇐ Php

[Anonymous]

У меня есть 2D-массив. Как я могу сгруппировать значения дат и объединить активные и пассивные значения для каждой даты?
[
["status" => "ONE", "active" => "103347.02", "passive" => " ", "date" => "2016-08-01"],
["status" => "TWO", "active" => "65.32", "passive" => " ", "date" => "2016-08-01"],
["status" => "THREE", "active" => "3258.39", "passive" => " ", "date" => "2016-08-01"],
["status" => "FOUR", "active" => "35470.01", "passive" => " ", "date" => "2016-08-01"],
["status" => "ONE", "active" => "152685.68", "passive" => " ", "date" => "2016-08-02"],
["status" => "TWO", "active" => "1739.33", "passive" => " ", "date" => "2016-08-02"],
["status" => "THREE", "active" => "1300.00", "passive" => " ", "date" => "2016-08-02"],
["status" => "FOUR", "active" => "31461.06", "passive" => " ", "date" => "2016-08-02"],
["status" => "ONE", "active" => " ", "passive" => "2236", "date" => "2016-08-01"],
["status" => "THREE", "active" => " ", "passive" => "4496", "date" => "2016-08-02"]
]

Ожидаемый результат:
[
["status" => "ONE", "active" => "103347.02", "passive" => "2236", "date" => "2016-08-01"],
["status" => "TWO", "active" => "65.32", "passive" => " ", "date" => "2016-08-01"],
["status" => "THREE", "active" => "3258.39", "passive" => " ", "date" => "2016-08-01"],
["status" => "FOUR", "active" => "35470.01", "passive" => " ", "date" => "2016-08-01"],
["status" => "ONE", "active" => "152685.68", "passive" => " ", "date" => "2016-08-02"],
["status" => "TWO", "active" => "1739.33", "passive" => " ", "date" => "2016-08-02"],
["status" => "THREE", "active" => "1300.00", "passive" => "4496", "date" => "2016-08-02"],
["status" => "FOUR", "active" => "31461.06", "passive" => " ", "date" => "2016-08-02"]
]


Подробнее здесь: https://stackoverflow.com/questions/394 ... ative-elem