Interchange Columns and Rows in a Table

[Lawrence]

Is it possible to interchange the columns and the rows in a tables together
with the data. Ex. if the rows represent the months and the columns represent
the customers and the data represents the sales for each month. how can I
change the customers in to rows and the months in to columns.

 

[Joel]

Use pastespecial. You have to paste the data in a new area on your worksheet
and then copy back to the original area after you finish.

1) Highlight the area you want transpose and copy.
2) Select the first cell where you want the tranposed data. Then right
Click and select PasteSpecial. Select transpose and press OK.

 

[Lawrence]

great help, thanks

Use pastespecial. You have to paste the data in a new area on your worksheet
and then copy back to the original area after you finish.

1) Highlight the area you want transpose and copy.
2) Select the first cell where you want the tranposed data. Then right
Click and select PasteSpecial. Select transpose and press OK.