How to move consolidate data from multiple rows to one row.

I have a spreadsheet that has multiple duplicate account numbers. I need to consolidate the data to one row in order to eliminate the other rows with the duplicate account number. What is the best way to do this? A sample of what I'm working with is attached.

hi Ncaljets. Can you upload a file showing how this should look after deduplicaiton as well? Cheers.

I've just updloaded what I want it to look like. Thanks!