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!