For the end-user, if there is a huge data, this transpose will be very useful, and it saves a lot of time instead of typing it, and we can avoid duplication. In this way, we can easily convert the given data from row to column and column to row in excel. In the above screenshot, we can see that rows have been changed to column and column has been changed to rows in excel. Once we click on transpose, we will get the below output as follows.Select the fourth option in paste special, which is called transpose, as shown in the below screenshot highlighted in yellow color.Right, click on the new cell, and we will get the below option which is shown below.Now select the new cells where exactly you need to have the data.Copy the entire data by pressing the Ctrl+ C Key.First, select the entire cells from A To G, which has data information.If we want to convert the rows to the column in excel, we can use the transpose function and apply it by following the below steps.

We can see that month data are row-wise and Part number data are column-wise. We will get the result converted to rows to columns.Ĭonsider the below example where we have a revenue figure for sales month wise.Choose to paste special, and we will find the transpose button.Start the cell by selecting and copying an entire range of data.You can download this Convert Rows to Columns Excel?Template here – Convert Rows to Columns Excel?Template TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (35+).Excel Conditional Formatting Based on Another Cell Value.SUMPRODUCT Function with Multiple Criteria.Compare Two Columns in Excel for Matches.

Change row to column in excel