This function returns a vertical range of cells as a horizontal range or a horizontal range of cells as a vertical range.
The array argument is a range of cells or an array that you want to switch.
This function uses the first row of the array as the first column of the new array and so on.
Use the INDEX function to get individual elements from the returned array.
Accepts an array. Returns an array.