Hi

I have a database in one column but each address field is in a different
row, so

Co
Add1
Add2
Sub

and then a repeat of the same for the next record. I want to have each
address field in it's own column. I know i can copy and paste special
transpose but this is a line by line task. Wondering if there was someting
else i could do

Cheers

--
Nenagh