Question

What function displays column data in a row and row data in a column?

Answer 1

Hello!

• Microsoft Excel has many functions to manage with database entered in worksheet and Transpose is one of the useful function.

• It just rotates the table (data area) of worksheet to convert rows into columns and columns into row

Thanks!!