Home Excel 2003 Transpose Flip Columns And Rows
Search MS Office A-Z | Search Web Pages/ Design A-Z
Flip Columns And Rows
- Select the block of data and choose Copy.
- Go to the first cell in the destination block, click the arrow beside Paste, and choose Transpose.
- The data that was in the top cell of a column becomes the first cell in a row running off to the right.
- If the data was in a row, the first cell in the horizontal row becomes the top of the column.