Parsing data to separate columns

Hello.

I can write a simple macro but not sure how to tackle this one. Attached is an Excel workbook. Column A has a few pieces of information: 1. Physician Name 2. Address 3. Phone Number and 4. Fax number 5. Blank rows. Some addresses have 2 lines and some have 1 line.

I need a macro that would put the address, phone number, and fax number all in separate columns. I want to end up with a spreadsheet that has all information in separate columns and Column A only left with physician name. The challenge is that some Column A information sets have 1 blank row and some more than that.

Any advice? Greatly appreciated.

Thank you!

Kate