List conversion Col - Rows

R

Ricky

Hi,

I have an extensive contact list with all the info in col A such
as ...

Richard Phelan
123 South St
PERTH WA 6000
T 08 9012345
M 0406 12345

Donald Duck
Managing Director
XYZ Pty Ltd
PO Box 123
WEST PERTH WA 6005
e: (e-mail address removed)

Each contact is seperated by 2 blank rows, and many have numbers of
"fields".

I would like to convert this list so as each record is contained in
the one row, with data in seperate cells across, like ...

Richard Phelan | 123 South St | PERTH WA 6000 etc ....
Donald Duck | Managing Director | XYZ Pty Ltd etc ...

Can anyone suggest a macro that could do this for me?

Thanks, Ricky
 
Top