![]() ![]() Select a range for the new array, here I select K3:L10, copy the below formula into it: Supposing you want to flip the orientation of range B4:I5 as the below screenshot shown, you can try as follows to achieve it.ġ. The transpose result: after transposing, the first row of the original array becomes the first column of the new array, the second row of the original array becomes the second column of the new array, the third row becomes the third column, and so on.Įxamples Example 1: Flip the orientation of a given range The TRANSPOSE function must be entered as an array formula with pressing Ctrl + Shift + Enter keys simultaneously.Ģ. ![]() The TRANSPOSE function will return an array in a new orientation based on a certain range of cells.ġ. Array ( required): An array or range of cells that you want to transpose.
0 Comments
Leave a Reply. |