After that is selected, you want to hit OK. What the transpose function does is it acts as a lookup and reference formula that flips the X and Y axis of a document and categorizes the data so. Regardless, you want to look for the part that says special and click on that.įrom here, you want to go to the transpose tool section and check that off. As a note, I am using Office 365, so my paste section might look different from what you see. With the data selected, you want to click on the “paste special” section. In this example, I went a few rows down, and I am still using column A. With the data selected, you want to go to the cell that you eventually want to paste the data in. If you are using a Mac, you can still use the quick commands by replacing the CTRL buttons with the Command button on your keyboard. If your document is huge, use the CTRL + Down Key and CTRL + Right Key to see if everything is selected. Once everything is selected, you will see everything highlighted in a light color, so you can do a quick eyeball check to see if everything is copied. To do this in Windows, you hit the CTRL + A button to select all the data. As a quick tip, you can use a command that will select all the cells on the page that have data in it. Within the document, you want to copy all the data that you want to switch around. All of this can be completed in less than 30 seconds.

In this blog post, I am going to show how to transpose this data into excel and how to move columns and rows in excel with a click of a button.

My goal is to swap the columns at the top of the excel document with the axis of data points on the left-hand side which are my KPI’s. I fall into the latter when it comes to analyzing trends.

Others like the dates and the names of people to be on the left-hand side. Some people like having their dates (or names of people) at the top of the document.

Transpose excel 365