Transpose Entire Sheet?

Try this:
Select all the data (not the whole worksheet) and copy.

Go to a new worksheet and Paste, Transpose.

My experiments with small data ranges and simple formulae worked but I can't vouch for more complicated formulae being properly adjusted.

If you have more rows than there are columns in the worksheet, you won't be able to do this at all.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

If that does not work for you, I suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Thanks for the feedback.