Moving Data

[Bonnie]

I am doing a copy and paste, when I paste my data it
lines up in Column A ; Rows 1 , 2, 3, & 4. Now I want to
take that same data and have it be in Row 1 ; columns a ,
b, c, & d. Is there an automated way to do this?

Example current data is:
Bob Smith
123 fouth street
Chicago, IL 60611

I need it to look like
Column A Column B Column C
Bob Smith 1234 fourth street chicago, il 60611

Thank you

 

[Andy B]

Bonnie

Copy it and then Edit / Paste Special / Transpose.

Make a backup before you try!!

Andy.