Ever wanted to transpose columns to rows or rows to columns?
It’s easy with the the Paste Special dialog.
Consider the following cells

I really want the data the transposed so that the rows are in columns.
So copy the original data, select the destination cell then select Paste Special from the Edit menu

Select the Transpose option at the bottom right and click OK. You can still use the other options like Value or Formats.