I saw this same question asked a couple of days ago...

[Guest]

But I can't find it know. I remember thinking that I should copy it for future use...hmmmmph

Anyway, can somegive me an exmple of how to move a column of data (A1:A25) into a row (such as B1:Z1) saving me from a C&P nightmare??

 

[Mudface]

Select the data you want and Copy it. Then right-click in the first cell you want your data to end up in and select Paste Special and Transpose.

 

[Guest]

Worked great, thanks a million!