Moving variable data from multiple same-client records to one client record

Max # of duplicates (entries per client) would be eight. It's a file that has almost 11,000 total records and about 10,200 unique client records. Attached is an abbreviated example.