Which operation converts a vertical range to a horizontal range during paste?

• A. Transpose
• B. Flip
• C. Mirror
• D. Swap

Answer: (A)

Transposing data is the action used to change orientation when you paste. If you copy a vertical range (a column) and choose Paste Special with the Transpose option, it pastes the data as a horizontal range (a row), and vice versa. This reorientation is exactly what you need to switch how the data is laid out without altering the values themselves. You can also achieve the same result with the TRANSPOSE function, which returns a transposed array that spills into the adjacent cells. The other terms don’t perform this orientation swap during paste, so they don’t accomplish converting a column into a row.