Note – If you change any data in the source dataset, it will reflect in your transpose data set also. The Transposed data will appear as in the below image. In the brackets enter the array or range you want to transpose.
We wish to select the destination cell as We have copied the columns- Month and Sales. Enter the formula in the destination cell where you want your transposed data to appear. In this method we will use a formula to convert the column data to row data. We will consider the same data set as above. You can also use the shortcut Ctrl + Alt + V to Paste Special Method 2 – Transpose using ‘Transpose Function’ The column data has now converted to row data as shown in the image below.
We have copied the Month and Sales column and selected the cell E6, as destination cell.Īs you click on Paste Special, a dialog box would appear as below:Ĭlick on the Transpose option in the dialog box. Select the destination cell in which you would like to paste your transposed data. To transpose the columns to rows, follow the given steps: Let us convert the column data to row data using Transpose command. The data set has a table portraying Sales made in each Month. Method 1 – Transpose using Paste Specialīelow is a given data-set. We have listed 2 most helpful ways to Transpose. There are many ways in which you can transpose. The Transpose option has made it easy to convert rows into columns and columns to rows. Transpose in Excel means to means to switch the rows to columns and vice versa.
#Excel transpose cells with common how to
Have you ever tried to transpose your data in Excel? Let us learn what is transpose and how to Transpose Data in Excel in 2 simple ways.
0 kommentar(er)
