Sometimes when you finish a project, you have this bright idea that the table would work better if you transposed the rows and columns. That is, if the column headings were row headings or if the row headings were column headings. Careful planning will let you avoid this frustration. However, if you remember how to transpose, the switch won't take too long regardless of table size. (Hey, we plan, but stuff happens!)
To see how this works, we will start with a simple table with typical column headings that might be found in a grading project. The first step is to select the table and copy it to the clipboard.
Once the table is copied to the clipboard, we select a cell on our spreadsheet where the "transposed" table should begin. Then we select Edit + Paste Special.
Note the selection of a new location for the transposed table. When the Paste Special is selected, a Paste Special Panel with many, many choices for pasting will appear. We are interested in the Transpose checkbox.
We will place a checkmark in the box and click OK to see the results of the transpose in the new location.
Note the swapping of column headings to row headings. Also note that the respective cell formats in the original table have been preserved in the transposed table. The ease of the process should not be used as a substitute for pre-planning!