where is the transpose button in excel 2010

The formula below changes the result from XLOOKUP from a horizontal configuration to a vertical configuration: =TRANSPOSE((XLOOKUP(value,lookup_range,return_range)) TRANSPOSE can be used to 'catch' and transpose the output from another function.

In the example shown, the target ranges have been formatted in a separate step. Note: TRANSPOSE does not carry over formatting. In the example shown above, the formulas in I5 and F12 are: =TRANSPOSE(B5:F6) // formula in I5 To transpose the horizontal range A1:E1 to a vertical array: =TRANSPOSE(A1:E1) // vertical to horizontal To transpose the vertical range A1:A5 into a horizontal array: =TRANSPOSE(A1:A5) // vertical to horizontal When given a vertical array, TRANSPOSE returns a horizontal array: =TRANSPOSE( If data in the source range changes, TRANSPOSE will immediately update data in the target range. TRANSPOSE can be used with both ranges and arrays. Transposed ranges are dynamic. When array is transposed, the first row becomes the first column of the new array, the second row becomes the second column of the new array, the third row becomes the third column of the new array, and so on. When given a horizontal range, TRANSPOSE converts it to a vertical range.

When given a vertical range, TRANSPOSE converts it to a horizontal range.In other words, TRANSPOSE 'flips' the orientation of a given range or array: The TRANSPOSE function converts a vertical range of cells to a horizontal range of cells, or a horizontal range of cells to a vertical range of cells.

Where is the transpose button in excel 2010