Which function displays row data in a column and column data in a row?
Explanation
Explanation
The Transpose() function in MS Excel, helps to interchange the values of rows to columns and vice versa. It function returns a vertical range of cells as a horizontal range.