move data

[chanelg]

How do I rapidly move data from cells A1 - A5 to A1-F1? I did this a couple years ago and thought is was in paste special but no luck this time.

 

[Dave Peterson]

I think you want
copy|paste special|check transpose.

but the "from" range can't overlap the "to" range.

maybe paste somewhere else first and then move it (two steps, now).

 

[chanelg]

Thanks Dave, its the can't overlap that was getting me. I appreciate it.