You might try importing the data into a temporary table and then run a script that loops the the records a d fields to create the records in the correct table.
You could try to "rotate" the table. In dutch that's called transpose. That way the branchcodes are vertical i.e. Records and the productCode, description and price become columns i.e. Fields