how do i tranpose one row to multiple column?

[ALEX]

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

 

[David Billigmeier]

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