Friday, October 30, 2020
Home Excel Sheet How to Transpose Columns and Rows in Excel?

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.

 

data

 

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

spreadsheet

 

  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?”

 

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

How to Earn Online?

How to Earn Online? Online Earn is a destination that covers almost everything related to online earning techniques. It tells you how to earn money...

Why Do Websites Get Hacked?

Why Do Websites Get Hacked? Every month several vulnerabilities are found in most plugins that are used by the developers on their websites. We notice...

Which Incredible Things You Can Do Using Php In 2020?

Which Incredible Things You Can Do Using Php In 2020? When we talk about the web, how can we forget PHP, which is one of...

What are Common On-page Optimization Mistakes?

What are Common On-Page Optimization Mistakes? On-page optimization needs your concentration for entire SEO battle. In any event, doing one apparently little thing incorrectly, or...

Recent Comments