Data relationships and trends may become more obvious and easier to comprehend if you transpose the spreadsheet row and column headings along with the data they contain.

How to Reconfigure a Horizontal Row to a Vertical Column in Excel. When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes ...