<p>Hey everyone,</p>

<p>I am trying to transpose large datasets in excel but it keeps giving me the message we can&#39;t paste because copy area and paste area aren&#39;t the same size. Is there a way to transpose all the data at one time instead of piece by piece? One dataset has a great amount of rows and columns. Thanks.</p>

Stack Overflow <a href="http://stackoverflow.com/a/1729980/19410">offers a solution</a> that uses GNU *awk* and should run considerably faster than R (if you plan on doing a lot of transposing).

Also something to keep in mind is that Excel makes Microsoft-y text files. You may need a tool like <a href="http://sourceforge.net/projects/dos2unix/">*dos2unix*</a> to convert them to something that works better with command-line tools.