Merging rows with similar data?

I can prepare one, I will have to remove any sensitive data beforehand though, I will get to it as soon as I have a free 20mins from work.

Thanks for the help!

EDIT: I have attached a small portion of the data, as you can see, not all rows have a duplicate like in the example.

Thanks again!