TRANSPOSE
Returns a range with exchanged rows and columns.
Syntax
TRANSPOSE(range)
range - the range which is to be transposed - Value type: range
Remarks
The function exchanges row and column coordinates of cell data values. So a value which has been in row 3 and column 4 will be in row 4 and column 3 afterwards.
