Combining Rows in Excel

[babs]

I have seen similar posts to this, but none quite like what I need help with...

I have a sheet where each row is an agreement, but not every cell in that row has a value and information for one agreement could be spread out onto multiple rows. I want each unique agreement to have one row. In the attached sample you will see there are a lot of blank cells on each row and information for one agreement number could be spread out between about six lines. If I could get everything associated with the same agreement/sub number on one line and have the other ones removed that would be great! I feel like when I go through options in my head it becomes much more complicated than it should be! The current sheet I'm working from has about 23,000 lines in it, so this will be a huge help!