Monday, August 10, 2020
Home Excel Sheet How to Transpose Columns and Rows in Excel?

How to Transpose Columns and Rows in Excel?

We use excel for storing and arranging our important data in rows and columns. Doing so, we make mistakes when we want to shift rows to columns and columns to rows, in other words, transposing rows and columns. Instead of putting the data, you wanted in columns, you put in rows. This changes the meanings. Hence, you end up entering the wrong information that makes it complex too. If you are working with formulas, everything gets complex. One mistake in the formulas can lead to wrong information. Let’s learn how to take the transpose of columns and rows in excel.

Let’s consider an example of a spreadsheet with the following data.


transpose columns and rows in excel.


Copy/paste is not the only way to put your data in the correct place. It might be confusing.

Let’s follow the step guide on how to transpose columns and rows in excel. to solve the issue:

  1. Open Microsoft Excel and select a blank spreadsheet


transpose columns and rows in excel.


2. Enter the data


enter the data



3. After entering the data, select the number of columns and rows containing the data and click right

4. Select the “Copy” option.




  1. Select a new empty cell to paste the copied data.



  1. Right-click and select the “Paste Special” option.

excel sheet


  1. In the “Paste Special” box, check the “Transpose” button.

transpose columns and rows in excel


  1. Click “Ok”.

transpose columns and rows in excel

You have done it now. Your file looks like this.


transpose columns and rows in excel


Note: If your information is in the Table structure and you take its transpose, the transpose choice won’t work. For this, you need to change the table to a range. Go to the Table tab. Select the “Convert to Range” option. You can likewise utilize the Transpose Function to take the transpose of the table.

Read more “How to use the freeze panes feature in excel to keep an area on the spreadsheet visible?”




Please enter your comment!
Please enter your name here

Most Popular

How to SEO work for small business owners ?

Website optimization for independent companies shouldn't be muddled. You can improve your site’s ranking in web search tools and get visitors to your business'...

How to optimize the Homepage of your website?

Just as you enter a store and observe how the entrance looks like. If it looks organized and well-managed, you stay there and shop...

How to start a laptop in a safe mode?

There are many possibilities when you want to start your laptop in a safe mode. If you believe it's malware that is influencing your...

How to use Bluetooth on a laptop?

Nowadays, many computers and laptops come with a built-in Bluetooth feature. But, if you’re using an outdated or old-fashioned PC, you might not find...

Recent Comments