How to convert columns to rows, or rows to columns

Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row,…