How to convert columns into rows and rows into columns in Excel
Microsoft Excel together with Microsoft Office suite is the most popular office software today. However, not everyone can master all the basic operations when using this office toolkit.
When working with Excel tables, sometimes you need to convert Excel columns into rows or convert data in Excel rows into columns, if retraining is very time consuming, just a tip that Network Administrator instructs below, you have It is easy to convert goods into columns or columns.
Note , the steps are the same for all versions of Excel.
- Download Microsoft Office 2016
- Download Office 2016 for Mac
Step 1: Open the Excel file that needs to convert columns into rows or vice versa.
Step 2: Blacken the rows you want to convert to columns, or vice versa. Right-click and select Copy or use Ctrl + C.
Step 3: Move to the location where you want to create the new table. Here, click on Paste Special .
Step 4: The Paste Special dialog box appears. Check the Transpose box. Click OK to finish.
So you can change the row into columns as shown below. The steps to convert columns into rows do the same thing. You copy the row to be converted into a column, then find the location you want to create the table, paste it specifically and check the Transpose option as above.
So with a very small trick, you can save a lot of time and effort in converting Excel data from columns to rows and vice versa right?
Refer to the following articles:
- Summary - 38 'priceless' shortcuts in Microsoft Excel
- MS Excel - Lesson 4: Working with lines, columns, sheets
- 10 ways to recover corrupted Excel files
I wish you all success!
You should read it
- How to fix columns and headlines in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to convert rows into columns and vice versa in Excel
- How to combine 2 columns Full name in Excel does not lose content
- MS Excel - Lesson 4: Working with lines, columns, sheets
- How to handle cells, columns, rows in a spreadsheet in Excel
- How to quickly Add and Delete rows and columns in Excel
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
May be interested
- Instructions for creating a PDF file from multiple image files on Windowspdfs are designed to support raw text with fonts, images, sound and many other effects. if you have a collection of photos and text documents that you want to scan to your computer in jpegs format, you can combine these files into one pdf file for easy sharing.
- Instructions for using Pareto, Histogram and Waterfall charts in Excel 2016excel 2016 has improved some new features. among them, there are 6 new charts that are waterfall, histogram, pareto, box & whisker, treemap and sunburst.
- Restore Sticky Note deleted on Windowsif you accidentally accidentally missed the important note, how to restore these note. please refer to the following article of network administrator.
- Instructions for deleting empty lines and columns in Excel 2016sometimes your spreadsheet has too many blank lines and empty columns look very messy and lose aesthetics. to make the spreadsheet look better you can delete these blank lines and blank columns. however, instead of manually deleting each column, each blank line is very time-consuming, especially with long spreadsheets with many empty columns and empty lines.
- Align margins in Google Docscompared to aligning margins in microsoft word, when creating margins on google docs is much simpler and easier.
- Fix the x80070005 error code in the Active Office processsometimes in some cases, users using office often make an error: we're sorry, something went wrong and we can't do this for you right now. please try again later. (0x80070005). even in case of installing office, this error occurs.