I need to convert a column of data to rows. The data is in INconsistent
format, i.e., some records have 4 lines and some have 5 or 6 or 7 lines. It
looks like this:

Gourley Real Estate, Inc.
A Smaller Company, for Better Results.
4908 Deerwood Drive
Raleigh, NC 27612 Phone:(919) 788-9772
Fax:
Email:
WebSite: http://www.michaelgourley.com


Holton Wilkerson - Broker, GRI
Leading The Way In Residential Real Estate
8312 Creedmoor Road
Raleigh, NC 27613 Phone:(919) 582-1638
Fax:(888) 580-8595
Email:
WebSite: http://www.holtonwilkerson.com

Sunshine Realty
Buying or Selling ANY House...Glenda Gets It Right!
PO Box 40157
Raleigh, NC 27629 Phone:(919) 810-0742
Fax:(919) 779-5650
Email:
WebSite: http://www.GetsItRight.com


Nariman Abar
CENTURY 21 VICKI BERRY REALTY
5312 Six Forks Rd Ste 21
Raleigh, NC 27609-4458 Office:(919) 782-9797



Marina Abbat
COLDWELL BANKER ADVANTAGE
7208 Falls Of Neuse Rd
Raleigh, NC 27615-3244 Office:(919) 847-2222



Charles R Abbott
C. ABBOTT PROPERTIES, INC.
7000 Harps Mill Rd STE103
Raleigh, NC 27615-3239 Office:(919) 844-6144

I would like for it to be transposed into horizontal format something like
this:

name address1 fax postcode telephone
name address1 address2 postcode telephone1 cell
name company address1 address2 fax postcode telephone

i.e., I don't care that the columns don't line up - I can take care of that.
I just can't transpose all of the data at one time. I would have to
individually cut and paste special w/ transpose.

I'm sure that this is an easy task for a person familiar with VB - but I'm
not. Can someone help me out?

TIA

Chuck