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.

1. Download Microsoft Office 2016
2. 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.

How to convert columns into rows and rows into columns in Excel Picture 1

Step 3: Move to the location where you want to create the new table. Here, click on Paste Special .

How to convert columns into rows and rows into columns in Excel Picture 2

Step 4: The Paste Special dialog box appears. Check the Transpose box. Click OK to finish.

How to convert columns into rows and rows into columns in Excel Picture 3

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.

How to convert columns into rows and rows into columns in Excel Picture 4

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:

1. Summary - 38 'priceless' shortcuts in Microsoft Excel

1. MS Excel - Lesson 4: Working with lines, columns, sheets

1. 10 ways to recover corrupted Excel files

I wish you all success!