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!

Jessica Tanner

Update 19 May 2020

You should read it

Instructions for drawing probability distribution charts in Excel
the following article details how to use histogram to plot probability distribution charts in excel. in order to use the histogram office, the analysis toolpak must be installed.
How to compare 2 documents in Word
the following article details how to compare 2 documents in word 2013.
Protect Header and Footer in Word
if you want users to be able to edit the text of word documents but cannot change important information such as author names ... recorded in the header or footer of the text, please follow this article.
How to format data in Excel
the following article details how to format commonly used data in excel.
How to create word art in Word
sometimes reading plain text is just a simple font that will be boring and not create accents in your text. therefore, i introduce to you the tool for inserting artistic words in word.
Copy Page Setup settings to another Sheet in Excel
the setup of page setup is very simple, but if you work with lots of sheet in excel you spend a lot of time setting up this. the following article shows you how to copy page setup settings to another sheet in excel.