list to tabular format

  • Thread starter Thread starter tt
  • Start date Start date
T

tt

I've downloaded a list of bookclubs off the web into excel. Is there anyway
I can change the tabular format like below. See list:

In Excel:
Bookstore: Book Classic Store

Address1: 2206-D Airport Blvd.
Address2: Westwood Square
City, State, Zip: Mobile, AL 36606
Phone: 334-479-1060
Fax: 334-476-4642
Contact: Adline Clarke

Bookstore: Campus Bookstore
Address1: 1013 Old Montgomery Road
City, State, Zip: Tuskegee Institute, AL 36088-1611
Phone: 337-476-1060



Tabular format

Bookstore Address1 Address2:
City, State, Zip Phone:
Book Classic Store 2206-D Airport Blvd. Westwood Square Mobile, AL 36606


Thansk
 
Back
Top