Correct Answer:
A. Transpose
Correct answer: Transpose. Transpose swaps rows and columns, turning rows into columns and back.
Background: In Excel, Paste Special offers Transpose, which flips a copied range on its side.
- Pivot: A PivotTable summarises data by grouping it, not by swapping rows and columns.
- Filter: It hides rows that fail a condition, and changes nothing into columns.
- Sort: It reorders rows by value, and swaps nothing.
Did you know? The TRANSPOSE function can flip a range live with a formula.
Memory trick: Transpose means turn it sideways.
Leave a Reply
You must be logged in to post a comment.