Consolidating data

[PamK]

I have a spreadsheet containing a unique ID in column A, however, there are duplicate ID's throughout the data with a few unique as well. Where the ID's are duplicated, I need to gather the data in columns Q through U and append to the first instance of the ID for as many times as the ID is duplicated and then delete those duplicated rows. Any help would be appreciated. I have attached a sample with 49 records plus a header.