Which function displays row data into column or column data into row?

The Transpose function in Excel is specifically designed to swap the orientation of data between rows and columns. It can:

Convert a vertical range of cells (column) into a horizontal range (row)

Convert a horizontal range of cells (row) into a vertical range (column)

This makes Transpose incredibly useful for rearranging data and adapting it to your desired format.

Here's why the other options aren't used for data transposition:

A. Hyperlink: This function creates links to websites or other locations within the workbook. It doesn't affect data arrangement.

B. Index: This function is used to extract a specific value from a range based on its row and column position. While it can be used for data manipulation, it doesn't directly transpose data.

D. Rows: This function doesn't directly manipulate data layout. It returns the number of rows in a reference.