Question

name the function that display row data in a column or column data in a row

Answer 1

it just rotates the tables of worsheet to convert rows into column and columns into rows. Transpose function will convert a horizontal range of cells into vertical and vertical range or cells into horizontal.