Not without some programming.
However, using the keyboard instead of the mouse makes it a quick and
*relatively* painless process. Use Ctrl-C to copy the data, move to the new
location and use
Alt-E then S E Enter. Takes less than a second, once you get
accustomed to it.
"SSD1" wrote:
I am collecting data that occurs in columns and want to transpose it to rows.
Can I avoid the "Paste Special/Transpose" route? Is there a way to
automatcially transpose the data every time I paste.
--
SSD1
|