how do i tranpose one row to multiple column?

I HAVE A ROW WITH ADDRESSES IN FORMAT
A
B
C
D
BUT I WANT TO TRANSPOSE TO LOOK LKE THIS
A B C D

Copy the records then... Right Click->Paste Special->Transpose


--
Regards,
Dave


"ALEX" wrote:

> I HAVE A ROW WITH ADDRESSES IN FORMAT
> A
> B
> C
> D
> BUT I WANT TO TRANSPOSE TO LOOK LKE THIS
> A B C D