![row to column excel for mac row to column excel for mac](https://www.lifewire.com/thmb/5FqIV0bHX3Zuh6Y4TEweGvyk4d8=/1155x1155/smart/filters:no_upscale()/ExcelSelectRow-5bdf316dc9e77c00510333da.jpg)
In this example, we are going to see how to use the transpose function with an array with the below example.Ĭonsider the below example, which shows sales data week wise where we are going to convert the data to columns to row and row to column vice versa by using the transpose function. If we are using the transpose function formula as an array, then we have CTRL+SHIFT +ENTER to apply it. When a set of an array is transposed, the first row is used as the first column of an array, and in the same way, the second row is used as the second column of a new one and the third row is used as the third column of the array. Array: The range of cells to transpose.we can convert rows to columns or columns into rows vice versa. In excel, a built-in function called Transpose Function converts rows to columns and vice versa this function works the same as transpose. In the above screenshot, we can see the difference that row has been converted to columns in this way, we can easily use the transpose to convert horizontal to vertical and vertical to horizontal in excel. Once you have chosen the transpose option, the excel row data will be converted to the column as shown in the below result.Select the Transpose option in that, as shown below.We will get the paste special dialogue box.
![row to column excel for mac row to column excel for mac](https://www.freecodecamp.org/news/content/images/2021/08/Screenshot-2021-08-06-at-12.42.39-PM.png)
Once you copy the data, choose the new cell location.Click on the cell and copy the entire range of data as shown below.
![row to column excel for mac row to column excel for mac](https://i1.wp.com/www.bradedgar.com/wp-content/uploads/2016/05/Column-freeze-panes.png)
We will see how to convert the column to row with the below steps. Suppose we need to convert the data column to rows in these cases TRANSPOSE function will be very useful to convert it, which saves time instead of entering the data. In this example, we will convert rows to the column in excel and see how to use transpose the employee salary data by following the below steps.Ĭonsider the above screenshot, which has id number, emp name, HRA, Allowance, and Special Allowance. 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.
![row to column excel for mac row to column excel for mac](https://support.content.office.net/en-us/media/0ac4d931-d85b-4016-b8b5-cd4e8509ff6a.png)
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.