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.
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.
Then click on the location where the data needs to be converted and right-click on that cell -> select Paste Special.
When the Paste Specia l dialog box appears, check the box before Transpose
Finally click OK to complete. And here is the result of converting columns to rows in Excel.
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.
You should read it
- How to convert Excel files to PDF online using Google Drive
- How to convert CSV files to Excel in bulk
- How to convert money into words in Excel, without an add-in, supports both 32-bit and 64-bit Excel
- How to convert PDF to Excel
- How to convert columns into rows and rows into columns in Excel
- How to convert commas to dots in Excel - Convert unit separator
- How to use the Convert function on Excel
- How to convert PDF files to Excel keeps formatting
May be interested
- How to temporarily hide rows and columns in Excel 2013excel 2013 has a feature that allows temporary users to hide one or more rows / columns in an excel spreadsheet. this feature is very useful in case you only want to print a part of the spreadsheet but do not want to delete other excess rows and columns.
- How to add rows and columns in Excelhow to add rows and columns in excel. the article shows you 3 ways to add rows (rows) or add columns in excel.
- How to fix column and header rows in Excel 2016how to fix columns and headlines in excel 2016. with an excel table with a large number of columns and rows, fixing columns and headlines is a necessary job, you can easily check. investigate and process data without confusion and waste n
- Spacing rows and columns in Excel beautifullyspacing rows and columns in excel beautifully. when editing text in excel, you will come across cases where rows or columns of unequal width make your text look bad. after editing is finished, we need to readjust for v
- Instructions for coloring alternating rows and columns in Excelalternating colors in excel is a useful technique to make your spreadsheet more visual. learn how to use conditional formatting in excel 2007 to 2016 to easily distinguish rows and columns.
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016how to add columns, delete columns, add rows, delete rows in word 2007, 2010, 2013, 2016. the following article helps you perform the operation of inserting columns, rows or simply deleting redundant columns and rows in data tables in extremely simple ways.
- Excel does not allow inserting additional columns and rows [FIXED]excel does not allow inserting additional columns or rows, so you cannot continue editing the document? tipsmake has found the cause and how to fix it
- Change the width of columns and the height of rows in Excelthe default column widths and row heights in excel may not match the data you enter. you want to change the width, height of rows and columns so that data is displayed fully on cells in excel.
- Hide and display columns and rows in Excelin the process of working with excel, you want to hide a certain row or column because of job requirements. the following article details how to display or hide columns and rows in excel.
- Instructions on how to color alternating rows and columns in Excelthe following article details how to color alternating rows and columns in excel. colored alternating rows. highlight alternating columns. colored alternating rows of columns provided there is data and no data.