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.
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.
You’ve hit the ball out the park! Incerdible!
Gosh, I wish I would have had that inforamtoin earlier!
That’s the best asnwer of all time! JMHO
I think you hit a blluseye there fellas!
This is way better than a brick & moartr establishment.