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.

Step 1: Highlight the data you want to convert to column -> right click -> Copy .

Step 2: At the new table position you want to display, right-click and then select Paste Special .

Step 3: A dialog box appears, select the Transpose item , then click OK to complete.

Result of the attributes converted to column headings (as shown):

You want to convert the column to a similar line of operation.

Good luck!