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

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

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

--
Regards,
Fred


<GARYJG2@HOTMAIL.COM> wrote in message
news:1154644559.124289.29420@b28g2000cwb.googlegroups.com...
>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 wrote:
> Post an example, and how you want it split up. There will be a way, but it will
> depend on your data.
>
> --
> Regards,
> Fred
>
>
> <GARYJG2@HOTMAIL.COM> wrote in message
> news:1154644559.124289.29420@b28g2000cwb.googlegroups.com...
> >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 wrote:
> Post an example, and how you want it split up. There will be a way, but it will
> depend on your data.
>
> --
> Regards,
> Fred
>
>
> <GARYJG2@HOTMAIL.COM> wrote in message
> news:1154644559.124289.29420@b28g2000cwb.googlegroups.com...
> >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
> >
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
leendert.aarts@ncr.com

Cherie Abbinanti
VP of Supply Chain
847-680-00000
64 Paddock Lane
LibertyvilleIL - 60048
abbs642@sbcglobal.net

Brian Abbott
Corporate Account Manager
Neopost LoopOne
512-697-0000
171 W. 6th Street
AustinTX - 78703
babbott@loopone.com

Nadim Abboud
Dir PWC Logistics University
PWC Logistics
965-987-0000
P.o. Box 254
Safat - 13115
nm.abboud@pwclogistics.com

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
sheikh.abdulhai@abdulla-fouad.com