CodeSteps

Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...

How to convert Columns to Rows (OR) Rows to Columns in Excel?

We arrange the data in Microsoft Excel in rows and columns. Sometimes it is required to rotate the data from columns to rows and vice versa. The below steps explains how to do this.

Step 1. Select the columns (OR) rows from Excel Spreadsheet.

Step 2. Copy the selected columns (OR) rows.

Step 3. Select the location in the spreadsheet where you want to paste the copied columns (OR) rows.

Step 4. Right mouse click from the selected location and select Paste Special… from the pop-up menu. It will display Paste Special dialog.

Microsoft Excel - Paste Special dialog
Microsoft Excel – Paste Special dialog

Step 5. Check the Transpose checkbox from Paste Special dialog and Click the OK button.

Step 6. It will display the copied columns as rows (OR) copied rows as columns.

This way we can transpose the columns to rows and vice versa in Microsoft Excel.

How to convert Columns to Rows (OR) Rows to Columns in Excel?

5 thoughts on “How to convert Columns to Rows (OR) Rows to Columns in Excel?

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top