Excel macro - copy data from one line, append

Hello,

I have a spread sheet created from a PDF to XLS program. I have lines in which the address appears on two lines, with the extra text falling to a line below. This data is in Column B and where this 2nd address line exists, the data in Column A is blank.

LN 1 Column A (Name) Column B (Address)
LN 2 ARNOLD, STEPHEN 123 Anywhere St, Some_City,
LN 3 Some_State Some_Postal_Code
LN 4 ARNOLD, MARK 321 Anywhere St, Some_City,
LN 5 Some_State Some_Postal_Code
LN 6 ARNOLD, DAVID 345 Anywhere St, Some_City,
LN 7 Some_State Some_Postal_Code

I wish to copy the 2nd line data, append it to the first (with a space added between) and then delete the 2nd line, leaving the address in one field and complete:

LN 1 Column A (Name) Column B (Address)
LN 2 ARNOLD, STEPHEN 123 Anywhere St, Some_City, Some_State Some_Postal_Code
LN 3
LN 4 ARNOLD, MARK 321 Anywhere St, Some_City, Some_State Some_Postal_Code
LN 5
LN 6 ARNOLD, DAVID 345 Anywhere St, Some_City, Some_State Some_Postal_Code
LN 7

I may wish to then delete that entire empty line, but that should be optional after we confirm that the line is, in fact, entirely blank, and move the remaining data in the sheet up.

LN 1 Column A (Name) Column B (Address)
LN 2 ARNOLD, STEPHEN 123 Anywhere St, Some_City, Some_State Some_Postal_Code
LN 3 ARNOLD, MARK 321 Anywhere St, Some_City, Some_State Some_Postal_Code
LN 4 ARNOLD, DAVID 345 Anywhere St, Some_City, Some_State Some_Postal_Code

I can record a macro, but it only applies to the one cell where I started and I can not apply elsewhere. Actually a find next would be great too to automate the procedure.

Can someone please help me create a macro for Excel v2011 Mac ? there are 6 worksheets in this workbook with over 60,000 lines in each. It was created from a 5803 page PDF file converted to XLSX

Thanks in advance, Stephen A