How to Transpose a Table In Microsoft Excel
Microsoft Excel spreadsheets consist of a series of horizontal rows and vertical columns that contain data for analysis. Sets of data cells (the intersections between columns and rows) make up a table of information. If you have a table of data that you need to move to another section of the worksheet with a different orientation (where the rows display as columns and vice versa), you can do so by transposing the information.
- Difficulty:
- Easy
Instructions
-
-
1
Select an empty set of cells in your Excel worksheet with the same number of columns and rows as your table, except you must switch the numbers to transpose the information properly. For instance, if you have a table with three rows and four columns, the empty cells you select must now have four rows and three columns.
-
2
Type "=TRANSPOSE(", which will start an active formula. With the function still open in your formula bar at the top of your Excel sheet, select the entire table that you want to transpose with your mouse. This automatically adds the cell range containing the table to your formula. When done, click ")" to close the formula.
-
3
Press "CTRL + SHIFT + ENTER" on your keyboard. After you press "Enter" the table information transposes to the new set of cells (formerly blank) in your worksheet. You can now select the other table, right-click and click "Clear Contents" to delete that duplicate information and work from the new table if you want.
-
1
