Online PHP editor | output for Wu08E

<?php $array = array ( array( 'SiteID' => 147, 'Amount' => '500.00', 'TransactionType' => 'Deposit' ), array( 'SiteID' => 147, 'Amount' => '500.00', 'TransactionType' => 'Redemption'), array( 'SiteID' => 147, 'Amount' => '1500.00', 'TransactionType' => 'Deposit' ), array( 'SiteID' => 147, 'Amount' => '200.00', 'TransactionType' => 'Reload' ), array( 'SiteID' => 150, 'Amount' => '100.00', 'TransactionType' => 'Deposit' ), array( 'SiteID' => 3, 'Amount' => '500.00', 'TransactionType' => 'Redemption' ), array( 'SiteID' => 150, 'Amount' => '200.00', 'TransactionType' => 'Redemption' ), array( 'SiteID' => 3, 'Amount' => '500.00', 'TransactionType' => 'Deposit' ), array( 'SiteID' => 3, 'Amount' => '200.00', 'TransactionType' => 'Deposit' ), array( 'SiteID' => 3, 'Amount' => '200.00', 'TransactionType' => 'Reload' ), array( 'SiteID' =>147, 'Amount' => '500.00', 'TransactionType' => 'Redemption' ) ); $result = []; foreach ($array as ['SiteID' => $id, 'Amount' => $amt, 'TransactionType' => $trn]) { $result[$id][$trn] = ($result[$id][$trn] ?? 0) + $amt; } var_export($result);