Merging Rows

[nzatmj]

Good morning,

I have a spreadsheet with approx. 5000 rows of data. About 20% of the rows are duplicates in a way.

For example, there are columns A-G. All rows have column A populated, then 80% have rows B-E, the rest have F-G. I need to figure out a way to merge the two rows together so that if column A has the same information, I can fill out the rest of the information.

I've attached a screen print of a sample I did. The actual spreadsheet has columns a-x. Hopefully this makes sense!

Thanks in advance for the help!

Nadia