Transposing data in Excel Not Working
<p>I have a file from which I copied a big column and tried to paste it in another excel using paste-special "transpose". But I was unable to do the transpose, it gave me an error.</p>

<p><code>Error: The information cannot be pasted because the copy area and the paste area are not the same size and shape</code></p>