[@JoselinMane]

I have a list of addresses in this vertical one cell column format:

Boston Park Plaza Hotel
50 Park Plaza
Boston, MA 02116
(Tele): 617-426-2000
(Website): http://www.bostonparkplaza.com

Hilton Boston Back Bay
40 Dalton Street
Boston, MA 02115
(Tele): 617-236-1100
(Fax): 617-867-6104
(Website): http://www.hiltonbostonbackbay.com

Loews Boston Hotel
Hotel and Event Space
350 Stuart Street
Boston, MA 02116
(Tele): 617-266-7200
(Fax):
(Website): http://www.Loewshotels.com/Boston-Hotel/

Mandarin Oriental, Boston
Luxury Five Diamond Hotel with 148 guestrooms, spa and restaurant
776 Boylston Street
Boston, MA 02199
(Tele): 617-535-8888
(Fax): 617-535-8889
(Website): http://www.mandarinoriental.com/boston

To this multi-row format:

Category Name description address city st zip ph fx website
Fashion and Retail Agent Provocateur Luxury Lingerie 123 Newbury Street Boston MA 02116 (Tele): 617-267-0229 (Website):  http://www.agentprovocateur.com
Fashion and Retail Akris 16 Newbury Street Boston MA 02116 (Tele): 617-536-6225 (Fax): 617-424-0227 (Website): http://www.akris.ch
Fashion and Retail Alan Bilzerian A four story brownstone that sums up fashion and objects for men and women 34 Newbury Street Boston MA 02116 (Tele): 617-536-1001 (Fax): 617-236-4770 (Website): http://www.alanbilzerian.com
Fashion and Retail Alan Rouleau Couture 4 Time Best of Boston Award Winning Custom Tailor & Designer 85 Newbury Street Boston MA 02116 (Tele): 617-424-7848 (Fax): 617-424-5544 (Website): http://www.alanrouleau.com
Fashion and Retail Alton Lane Bespoke Men’s Clothing.  Revolutionizing the way men shop – one appointment at a time 91 Newbury Street, 2nd Floor Boston MA 02116 (Tele): 857-233-2873 (Website): http://www.altonlane.com
Fashion and Retail Alex & Ani Unique jewelry that is powerful, meaningful and spiritual, that inspires all who wear it! 115 Newbury Street Boston MA 02116 (Tele): 617-421-0777 (Fax): 617-421-1777 (Website): http://www.alexandani.com
Fashion and Retail Alexis Bittar 130 Newbury Street Boston MA 02116 (Tele): 617-236-0505 (Fax): 617-421-1777 (Website): http://www.alexisbittar.com
Fashion and Retail Allen Edmonds Shoe Corporation American crafted timeless and contemporary men’s footwear and accessories 36 Newbury Street Boston MA 02116 (Tele): 617-247-3363 (Website): http://www.allenedmonds.com
Fashion and Retail Allsaints Spitalfields Women’s and Men’s clothing 122 Newbury Boston MA 02116 (Tele): 617-517-0894 (Website): http://www.us.allsaints.com
Fashion and Retail Ann Taylor Retail clothing 18 Newbury Street Boston MA 02115 (Tele): 617-262-0763
Fashion and Retail Athleta Women’s performance brand 92 Newbury Street Boston MA 02116 (Tele): 617-587-9830 (Website): http://www.athleta.com

I have been going line by line and using the Transpose function in Excel.

Is there an easier way to do this?

As you will note not all addresses are consistent, some have websites, some don’t, some have fax number, some don’t, etc.

Thanks

[Steven Zahm]

@ JoselinMane

re: I have been going line by line and using the Transpose function in Excel.
Is there an easier way to do this?

Sorry, none that I know of.

[@JoselinMane]

Thanks, I just hired someone from Fiverr to do it for me. http://www.fiverr.com/gayan48 Great resource (site and person). The work was done promptly and professionally.

[Author]

Posts