I am trying to transpose large datasets in excel but it keeps giving me the message we can't paste because copy area and paste area aren'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.
Expect answers which recommend you not use Excel. They are correct :)
But if you must, the correct option is "Paste Special", then check "transpose". It sounds like you are trying to paste into the same area from which you copied, hence the error message. Try pasting to a new area or worksheet.
Thanks for your response. I was told to use excel to first organize all the data then once ready to analyze I would be using software such as R and banjo but I am just using excel to post data on a forum with one of my committee members for a group of our PhD cohort to see.