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


wrote in message
ups.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


wrote in message
ups.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


wrote in message
ups.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


Cherie Abbinanti
VP of Supply Chain
847-680-00000
64 Paddock Lane
LibertyvilleIL - 60048


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


Nadim Abboud
Dir PWC Logistics University
PWC Logistics
965-987-0000
P.o. Box 254
Safat - 13115


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