Tip 203 – Quickly Rearrange Your Data in Excel

If you find after entering data into an Excel worksheet that you have it arranged in columns when it might be better arranged in rows (or vice versa) you can reorder it. To do this, select all the data including the column and row headings and, from the Home tab on the ribbon, click Copy. Click in the top left cell where the data should start and choose Paste > Paste Special > Transpose and click Ok. You can then delete the rows containing the original data.