Question

Name the function that displays row data ina acolumn or column data in a row

Answer 1

It just rotates the table (data area) of worksheet to convert rows into columns and columns into rows. Transpose function will convert a horizontal range of cells into vertical and vertical range or cells into horizontal.