Merge Multiple Records for Single Client

I have 1500+ records, with the data pulled in from 4 tables. This means that some of the clients have more than 1 record, although the product is different in each record, so I need to be able to mer...