dear sir

the individual addresses are separated by :
Title: Mrs
Name: Johan
address1: Block 1 - Heavens Flat 404
address2: Cantonment area
address3: City
Zip: 5600070

as i mentioned earlier, there are three columns
with 3 to 5 rows for each address.

will transpose method help? if so, please help me
how can it be done.

thanks

m s narayanan