HomeApplicationOffice informationExcel - Convert columns to rows in Excel

Excel - Convert columns to rows in Excel

The technique of converting columns into rows or vice versa, converting rows into columns is used quite conveniently and quickly in Excel thanks to the Transpose tool. The following is a guide to performing this technique for those who do not know.

Excel - Convert columns to rows in Excel Picture 1

How to convert columns to rows in Excel

Step 1 : Open the Excel data file that you want to convert columns into rows

Step 2 : Select (highlight) the columns (or rows) you want to convert into rows (columns) --> then press Ctrl + C to copy (or click right-click and select the copy function ) in the function panel that appears when we right-click.

Excel - Convert columns to rows in Excel Picture 2

Then click on the location where the data needs to be converted and right-click on that cell -> select Paste Special.

Excel - Convert columns to rows in Excel Picture 3

When the Paste Specia l dialog box appears, check the box before Transpose

Excel - Convert columns to rows in Excel Picture 4

Finally click OK to complete. And here is the result of converting columns to rows in Excel.

Excel - Convert columns to rows in Excel Picture 5

With the above not too difficult operations, you can simplify converting columns into rows on Excel spreadsheets, thereby saving you a lot of time and effort compared to manually having to re-enter data if you accidentally make a mistake. wrong.


A trick in Excel that is also followed by many people is how to serialize data in Excel columns. Numbering in columns helps you save time with data tables of up to thousands of rows, if If you don't know clearly, please refer to Taimienphi.

4 ★ | 1 Vote

You should read it

May be interested

  • How to install the latest version of Foxit Reader on your computerPhoto of How to install the latest version of Foxit Reader on your computer
    foxit reader is a popular pdf file reading software used by many people today. installing the new version of foxit reader helps users read, edit and work with pdf files quickly and easily.
  • The simplest way to edit PDF filesPhoto of The simplest way to edit PDF files
    if you've ever tried editing pdf files, you've surely discovered that it's not as simple as editing microsoft office documents. some people still have to spend a lot of time and effort making a new pdf when they cannot edit the old pdf file. in this article, tipsmake will guide you through the simplest ways to edit pdf files so you don't have to be confused when performing tasks related to this format anymore.
  • How to copy or duplicate an entire sheet in Google SheetsPhoto of How to copy or duplicate an entire sheet in Google Sheets
    basically, moving or copying the entire content of a google sheets worksheet is not too different from what you may be familiar with when working on microsoft excel.
  • Round function, how to use rounding function in Excel - Rounding functionPhoto of Round function, how to use rounding function in Excel - Rounding function
    the round function in excel has many practical applications. below are details on how to use and the round formula in excel.
  • 2 ways to repeat title bars in Word for tablesPhoto of 2 ways to repeat title bars in Word for tables
    repeating titles in word is essential when you have a data table that is many pages long. repeating the table title on the next page will help readers easily understand the content in each column. there are 2 ways to repeat the title bar in a word table: using repeat header rows and customizing in table properties.
  • Instructions on how to cross cells in ExcelPhoto of Instructions on how to cross cells in Excel
    the operation of dividing 1 cell into 2 diagonal triangle cells with a line in excel is an extremely basic operation and is often performed in the process of creating tables in excel.

Office information