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.
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:
- Open Microsoft Excel and select a blank spreadsheet
2. 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.
- Select a new empty cell to paste the copied data.
- Right-click and select the “Paste Special” option.
- In the “Paste Special” box, check the “Transpose” button.
- Click “Ok”.
You have done it now. Your file looks like this.
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.