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

Explanation: 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.