Advanced Transpose

[goleafsgo7680]

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.

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>

 

[Special-K99]

VBA solution I would think, and to anyone thats going to tackle this (not me) note the number of lines differs for each customer.

1st customer) 4 lines + postcode + phone + fax + email + website
2nd customer) 4 lines + postcode + phone + email (no fax, no website)
3rd customer) 4 lines + postcode + phone + fax + email + website
4th customer) 4 lines + postcode + phone + fax + website (no email)