G
GTRich
I have been tasked with putting together a list of a company's
distributor using their website. I run a regional search on their
website and come up with results, which I then paste into excel.
Unfortunately, these all appear in Excel in rows, such as the following
format:
Smith's Leather
10 Main Street
Anytown, USA 01776
Phone: 202-555-1000
Fax: 202-555-1001
Dealer Type: Retailer
Brands: Coach, Gucci
There is a space between each business's information. To further
complicate things, the lengths of the entires vary, as some have email
addresses, website URLs, and fas numbers, while others do not. does
anyone know of a colution to getting these entries out of the single
first column and breaking them up into categorized columns or is this
just a massive data entry project?
distributor using their website. I run a regional search on their
website and come up with results, which I then paste into excel.
Unfortunately, these all appear in Excel in rows, such as the following
format:
Smith's Leather
10 Main Street
Anytown, USA 01776
Phone: 202-555-1000
Fax: 202-555-1001
Dealer Type: Retailer
Brands: Coach, Gucci
There is a space between each business's information. To further
complicate things, the lengths of the entires vary, as some have email
addresses, website URLs, and fas numbers, while others do not. does
anyone know of a colution to getting these entries out of the single
first column and breaking them up into categorized columns or is this
just a massive data entry project?