goleafsgo7680
New Member
- Joined
- Nov 24, 2016
- Messages
- 1
Hello everyone i'm new to the forum and hoping i can get some advice? I have a list of 360 customers in a single column. Each customer has a company name,contact name, address,phone,fax,email,website. Iwould like to pull each customer from that list and put them in a separate spreadsheet in their own rows. Can anyone help? I would like it to transpose like below. I have used the transpose in paste special, but it is taking way too long. Any help would be great.
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
AltaGas Ltd. | AltaGas Ltd. | Todd Jeffrey | 382 Wellington St. W., Suite 201 | Chatham, ON | N7M 1K4 | Phone: (519) 436-1420 | Fax: (519) 436-1574 | E-mail:todd.jeffrey@altagas.ca | Website: Home | AltaGas | |
Todd Jeffrey | Ann Malone Salon | Ann Malone | 501 Baldoon Rd | Chatham, Ontario | N7L 5A9 | Phone: 519-358-7062 | E-mail:amalone1234@gmail.com | |||
382 Wellington St. W., Suite 201 | Apollo Property Management | Heather Woodhouse | 186 Chatham St. N., PO Box 1649 | Blenheim, Ontario | N0P 1A0 | Phone: 519-676-7467 | Fax: 519-676-6640 | E-mail:heather@apollopm.ca | Website: Apollo Property Management - Chatham-Kent | |
Chatham, ON | Applied Computer Solutions | Bill Brough | 3020 St. Etienne Blvd | Windsor, Ontario | N8W 5E6 | Phone: 519-944-4300 | Fax: 519-944-4247 | Website: Applied Computer Solutions | ||
N7M 1K4 | ||||||||||
Phone: (519) 436-1420 | ||||||||||
Fax: (519) 436-1574 | ||||||||||
E-mail:todd.jeffrey@altagas.ca | ||||||||||
Website: Home | AltaGas | ||||||||||
Ann Malone Salon | ||||||||||
Ann Malone | ||||||||||
501 Baldoon Rd | ||||||||||
Chatham, Ontario | ||||||||||
N7L 5A9 | ||||||||||
Phone: 519-358-7062 | ||||||||||
E-mail:amalone1234@gmail.com | ||||||||||
Apollo Property Management | ||||||||||
Heather Woodhouse | ||||||||||
186 Chatham St. N., PO Box 1649 | ||||||||||
Blenheim, Ontario | ||||||||||
N0P 1A0 | ||||||||||
Phone: 519-676-7467 | ||||||||||
Fax: 519-676-6640 | ||||||||||
E-mail:heather@apollopm.ca | ||||||||||
Website: Apollo Property Management - Chatham-Kent | ||||||||||
Applied Computer Solutions | ||||||||||
Bill Brough | ||||||||||
3020 St. Etienne Blvd | ||||||||||
Windsor, Ontario | ||||||||||
N8W 5E6 | ||||||||||
Phone: 519-944-4300 | ||||||||||
Fax: 519-944-4247 | ||||||||||
Website: Applied Computer Solutions | ||||||||||
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>