Excel - Convert columns to rows in Excel

If you have an Excel file and enter data in the wrong row or column or vice versa, what will you do? Would you delete it and re-enter it? That takes up a lot of your time. Let's see how taimienphi.vn guides you on how to convert columns into 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 1Excel - 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 2Excel - 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 3Excel - 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 4Excel - 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 5Excel - 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