Hi,

I'm weak w/ excel, so someone will have to work me through this slowly if
I'm going to figure it out.

I have a master list a couple hundred pages long in word that has the
contact info for various organizations on it. The entries are all different
sizes and some inlcude discriptions. There are also many, many repeat
entries. I'm assuming the best way for me to get rid of the repeat entries
will be to make a list out of it in the end and just manually chose the best
entry for the repeats.

I want to transpose it from the one column it currently occupies in excel to
one row with several columns for each organization without have to paste
special|transpose for each entry.

The enties are sperated by a blank cell.

It would be awesome if the final list could output everything in the same
order. E.x. Organization|contact|email|phone|address|description
And the entries that didn't have a phone number would just have a blank
there. The data isn't uniform, however, so I don't think that it would be
worth the effort to figure out how to do this.

Can someone help me create a macro that will do this?

Here is an example of the data:

Davidson Films, Inc. ¨
668 Marsh St.
San Luis Obispo, CA 93401
Phone: (805) 594-0422
dfi@davidsonfilms.com
http://www.davidsonfilms.com/
Notes: Since 1955 producing quality videos for colleges, school districts
and eductors concerned with Human Development, Cognitive Psychology, Teacher
Training and Rhetoric.

DeBeck Educational Productions
3873 Airport Way, Box 9754
Bellingham, WA 98227-9754
Phone: (604) 739-7696
www.debeck.com
<blank cell>
William Greaves Productions Inc. ¨
230 W. 55th St.
New York, NY 10019
Phone: (212) 265-6150, (800) 874-8314
Fax: (212) 315-0027
www.williamgreaves.com
WmLGreaves@aol.com
<blank cell>
James Agee Film Project ¨
909 West Main St. 2B
Charlottesville, VA 22903
Phone: 800-971-2921
www.ageefilms.org
<blank cell>