Convert multiple rows to single row

I have a database of addresses that has each address as several rows which I want to convert into a single row. In the source file there is a blank row between records. I have attached a sample file with two sheets in it. One is the "before" data format and the other sheet is the "after" example of how I would like it to come out. We have thousands of records to convert so I need something that can be automated instead of a massive cut and paste operation.

Here is the sample:

sample conversion.xlsx

Many thanks for any help on this!

This looks like a great solution, but pardon my ignorance about how to actually apply it to the "before" sheet. What are the steps to make it come out in the "after" format since I have to do this to thousands of records?
Thanks again,

This is excellent and now I see how it works. Thanks so much!