Excel stores your data using a grid of cells. Rows are named with numbers and columns are named with letters. Sometimes you may want to transpose your data. For example, assume you have a worksheet like this.
Then sometimes you would want to switch rows and columns like this.
There are few different ways to do this. In this post I will show you how to do this using the Paste Special method.
First select the range of data you want to transpose. Remember to include row and column labels if there are any.
Then copy that data. You can press Ctrl + C from the keyboard or you can select “Copy” from the Home tab.
Or else you can right click on one of selected cells. Then select “Copy” from the shortcut menu.
You can use one of the above three methods to copy the data. Next you need to use the “Paste Special” method. Select the first cell where you want to paste your data. Then click on the dropdown button next to “Paste” in the “Home” tab.
Then Excel will show you various paste options available. Select the “Transpose” option from the list.
Or else you can right click on the first cell where you want to paste the data. Then select the “Transpose” option from the shortcut menu.
And this option is also available under the Paste special.
Also see:
How to transpose columns and rows using VBA