<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>

<p>Excel is not for <code>Bioinformatics</code>.</p>

<p>Use R to transpose the data matrix.</p>

<pre>
data &lt;- read.table(&quot;your_file_location&quot;, sep = &quot;\t&quot;, comment.char = &quot;&quot;, stringAsFactors = F, header = T)

transpose_data &lt;- t(data)</pre>
