Switch rows to columns and columns to rows

Please purchase the course before starting the lesson.

You can easily get a row of data converted to a column or a column to a row with paste special.

Paste Special Transpose

Paste Special Transpose

Convert entire reports from columns to rows

Paste Special Transpose

To see the full course contents click here.

Back to: Intermediate Excel Course > The Specials- GOTO and Paste