Excel Function : TRANSPOSE
Category
Lookup and reference
Description
Returns the transpose of an array
Microsoft Excel Reference Page
https://support.office.com/en-us/article/TRANSPOSE-function-ed039415-ed8a-4a81-93e9-4b6dfac76027
Syntax and Description of the TRANSPOSE Excel Function
TRANSPOSE(array) The TRANSPOSE function returns a transposed version of the input array. The input array must be a rectangular array.
About TRANSPOSE Excel Function
TRANSPOSE is an Excel function that allows you to rotate the data in a range or array so that the columns become the rows, and the rows become the columns. This can be useful when you want to rearrange data in a certain order, or when you want to compare data side by side.