Transposes the rows and columns of an array.
Array represents the array in the spreadsheet that is to be transposed.
You can find a general introduction to using Array functions on top of this page.
In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press Shift + Ctrl + Enter. Or, if you are using the Function Wizard, mark the Array check box. The transposed array appears in the selected target range and is protected automatically against changes.
The above table is 2 rows, 4 columns. In order to transpose it, you must select 4 rows, 2 columns. Assuming you want to transpose the above table to the range A7:B10 (4 rows, 2 columns) you must select the entire range and then enter the following:
Then make sure to enter it as matrix formula with Shift + Ctrl + Enter. The result will be as follows: