India Exam Junction
[Election Kanungo Sept, 2021]
10. In Excel, which function displays the row data in a column and a column data in a row?
Hyperlink
Index
Rows
Transpose
Correct Answer :
Transpose
Solution
The Transpose function in Excel is used to switch the orientation of data, converting row data into column data and vice versa. This can be done by using the TRANSPOSE() function or the "Paste Special > Transpose" option. It’s especially useful for reorganizing data without manually copying and pasting.