Suppose you have a column of data and want to arrange it in a row rather than having it in a column, you can do so using the ‘paste special’ feature in Microsoft Excel.
- Copy the cells of the column you want to convert to a row.
- Right-click the first cell of the row you want to move the data to.
- Click ‘Paste special’ from the context menu
- Select ‘Transpose’ (at the lower right of the dialog box) and then ‘OK’