If the return range is larger than the source range/array to be rotated, you will get #N/A errors in the extra cells.The TRANSPOSE function will update the result area automatically when there are changes in your workbook, just like any function. Alternatively, you can use Copy and Paste Special > Transpose However, this is one-time rotation.Press the CSE key combination instead of just pressing the Enter key.

Make sure that your range selection before entering function can fit the output data.

A video demonstrating how to use this function can be found here: How to transpose the rows and columns of a data table Like how we use TRANSPOSE in excel TRANSPOSE In Excel The TRANSPOSE function in excel helps rotate (switch) the values from rows to columns and vice versa. The TRANSPOSE function in excel flips the orientation of a range from horizontal to vertical and vice versa.

Excel automatically wraps your formula with curly braces ( ) to show that this is an array function. For example, if your array has 7 rows and 11 columns you need to select 11 rows and 7 columns to place the values.Īfter selecting a suitable range, enter the formula and apply the CSE key combination (press Enter while holding Ctrl and Shift. Select a range that can fit the transposed version of your array.

Unlike regular functions, you also need to select all cells you want to populate, before entering the formula. All you need to do is enter the reference of the range or an array. The TRANSPOSE function requires a single argument. An array or range of cells that you want to rotate.

Excel formula to transpose data