You can use the traspose Array Function. Look on
http://www.auditexcel.co.za/lookupandreference.html for a video clip on the 2
methods to transpose data.

"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