Select the data you need to convert, and click Kutools > Range > Transform Range. If you want to move data from column(s) to row(s), you can apply the Transform Range utility of Kutools for Excel to quickly convert one column to one row or multiple rows, or convert one row to one column or multiple columns.Īfter installing Kutools for Excel, please do as below:( Free Download Kutools for Excel Now!)ġ. Select the column(s) you want to move to row(s), and press Ctrl + C keys together to copy the selection, and select a cell you want to place the result, and right click to show the context menu, and click Paste Special > Transpose. In Excel, if you want to move data from one column to a row or vice versa, you can use the Paste Special function. Transpose cross table to list table or vice versa by Transpose Table Dimensions Move data form column(s) to row(s) or vice versa by Transform Range Move data form column(s) to row(s) or vice versa by Paste Transpose

If you are interested in this job, please go to below for details. In this article, I am going to talk about how to move data from column(s) to row(s) in Excel. Now when you return to your spreadsheet, the column headings should be letters (A, B, C, D) instead of numbers (1, 2, 3, 4).How to move data from column(s) to row(s) or vice versa in Excel?

Then uncheck the option called ' R1C1 reference style' and click on the OK button. When the Excel Options window appears, click on the Formulas option on the left. To change the column headings to letters, select the File tab in the toolbar at the top of the screen and then click on Options at the bottom of the menu. When the column headings are numeric values, R1C1 reference style is being displayed in the spreadsheet.

In the example below, the column headings are numbered 1, 2, 3, 4 instead of the traditional A, B, C, D values that you normally see in Excel. If your spreadsheet shows the columns as numbers, you can change the headings back to letters with a few easy steps. How do I change the column headings back to letters such as A, B, C, D?Īnswer: Traditionally, column headings are represented by letters such as A, B, C, D. Question: In Microsoft Excel 2016, my Excel spreadsheet has numbers for both rows and columns.

Change excel columns to rows