TIPS - Paste Special to Transpose

Paste Special to Transpose

Paste Special to Transpose

You've got a bunch of rows. You want them to be columns. Or vice versa. You would go nuts moving things cell by cell. Copy that data, select Paste Special, check the Transpose box, and click OK to paste into a different orientation. Columns become rows, rows become columns.