Which function switches row data into a column or column data into a row?
Correct answer B. Transpose
Explanation
TRANSPOSE returns a range with its orientation flipped, so a horizontal row becomes a vertical column and vice versa. Paste Special also offers a Transpose option.
Answer checked How we write and check questions
Discussion