HOW TO MAKE A MAILING LIST IN ONE COLUMN HAVE CONSISTANT ROWS

[GARYJG2]

I have a mailing list that is all in one column. I know how to separate
each line of information into a separate column if each person has the
same amout of rows. My problem is some of the name have 5 rows of
information and some have 6 - is there a way to make the row consistan
so I can use then use the offset to separate into different columns

 

[Fred Smith]

Post an example, and how you want it split up. There will be a way, but it will
depend on your data.

 

[GARYJG2]

Post an example, and how you want it split up. There will be a way, but it will
depend on your data.

 

[GARYJG2]

Post an example, and how you want it split up. There will be a way, but it will
depend on your data.

This is what the mail list looks like - some have 7 lines and some have
6. Other then going in and adding and line to make each name a
consistant number of row is there any formula that would do this?
When I have a consistant number of rows for each name I can spit each
row into a separate column.

Leendert Aarts
Director EMEA & CFC-R Logistics
NCR Corporation-European Log
31-10-0000
Columbusstraat 12-14
Rotterdam-Albrandswaard - 13165AD
(e-mail address removed)

Cherie Abbinanti
VP of Supply Chain
847-680-00000
64 Paddock Lane
LibertyvilleIL - 60048
(e-mail address removed)

Brian Abbott
Corporate Account Manager
Neopost LoopOne
512-697-0000
171 W. 6th Street
AustinTX - 78703
(e-mail address removed)

Nadim Abboud
Dir PWC Logistics University
PWC Logistics
965-987-0000
P.o. Box 254
Safat - 13115
(e-mail address removed)

Sheikh Abdul Hai
Logistic & Warehousing - Asst. G.M.
Abdulla Fouad Holding Company
00 966 3 857 0000
Abdulla Fouad Co. Ltd --Bldg,-Dammam-Saudi-Arabia
Dammam - 31411
(e-mail address removed)