Hi,

I have an extensive contact list is column A, with each contact
separated by 2 empty rows.

Each contact has a varying amount of info such as address, phone
numbers etc, so some contacts occupy 5 lines, some 7 etc in columns A.

My problem - how do I re-arrange all these contacts in col A so that
one contact is displayed in one row. This will then have all my 300
contacts being displayed in rows A1 down to A300.

Any help with a macro to achieve this would be greatly appreciated.

Regards, Ricky