I need some help with the following:
In the attached "Tab delimited data" file i have records with the same customer number (3rd column) but with different account number (1st column).
I am in need of a PHP script that can merge some of the columns with the same customer number into one record as shown in the attached "needed result" file (tab delimited).
The columns that need to be merge based on the customer number column are "account number", "balance", "past due" and "total due".
The customer number is everything before the "/" in the column.