Which function display a row data in column or column data in a row?

The function used to display row data in a column or column data in a row is called "TRANSPOSE." In spreadsheet applications like Microsoft Excel or google Sheets, you can use the TRANSPOSE function to switch the orientation of a range of cells, transforming rows into columns and vice versa. For instance, the formula =TRANSPOSE(A1:B2) will convert the specified range from rows to columns or columns to rows, depending on the original structure.