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.

Picture 1 of How to convert rows into columns and vice versa in Excel

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

Picture 2 of How to convert rows into columns and vice versa in Excel

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

Picture 3 of How to convert rows into columns and vice versa in Excel

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

Picture 4 of How to convert rows into columns and vice versa in Excel

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

Picture 5 of How to convert rows into columns and vice versa in Excel

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

Good luck!

ncG1vNJzZmismaXArq3KnmWcp51ktbDDjK2mZpufo8OmvtNmqaivo2K2r8DOZpqopKWiu7R5wKebZq6ZmLJuwsSrqpplmaN6psTCnqM%3D