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.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.
0 Comments
Leave a Reply. |