How to convert rows into columns and vice versa in Excel
The following article contains detailed instructions How to convert rows into columns and vice versa in Excel.
Assuming I have the following data table, the attributes that are in the row I want to turn into columns.
How to convert rows into columns and vice versa in Excel Picture 1
Step 1: Highlight the data you want to convert to column -> right click -> Copy .
How to convert rows into columns and vice versa in Excel Picture 2
Step 2: At the new table position you want to display, right-click and then select Paste Special .
How to convert rows into columns and vice versa in Excel Picture 3
Step 3: A dialog box appears, select the Transpose item , then click OK to complete.
How to convert rows into columns and vice versa in Excel Picture 4
Result of the attributes converted to column headings (as shown):
How to convert rows into columns and vice versa in Excel Picture 5
You want to convert the column to a similar line of operation.
Good luck!
You should read it
- How to convert columns into rows and rows into columns in Excel
- How to convert data from columns to rows in excel is extremely simple
- How to move rows and columns in Excel
- This is a very useful function in Google Sheets but not many people know it
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to handle cells, columns, rows in a spreadsheet in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to quickly Add and Delete rows and columns in Excel
- How to temporarily hide rows and columns in Excel 2013
- How to add rows and columns in Excel
- How to fix column and header rows in Excel 2016
- Spacing rows and columns in Excel beautifully