Thursday, July 31, 2008

Excel change columns to rows, or rows to columns

Issue:
While working in Excel you realize that you wish the data was oriented differently in your spreadsheet.

Quick:
Select data, copy, select empty area, paste special, check transpose box.

Visual:


























Learning:
Once you realize that your data is not in the best orientation you might be tempted to start over or to copy your data cell by cell to the right orientation. Hold everything, there is a better way. Using the Transpose feature in Excel you can switch around your column and row data with a few clicks of the mouse. In the example only one row of data is being transposed to a column but you can also select an entire block of data and transpose will switch all the selected rows and columns at once.

-Select a row, column, or block of data to transpose.
-Right click the selected cells and select paste special from the menu
-Right click an empty section of the spreadsheet and select Paste Special from the popup menu
-On the Paste Special menu check the box for Transpose-Click OK

3 comments:

ramin1981 said...

thanx this is was good

Anonymous said...

thanks

Alex said...

In ms excel I often do reports, but some days ago I lost all my reports for some seconds on undetermined cause. I was terribly upset. Only yesterday I luckily dug up a program, which assisted me. What is more it would aid in almost every similar trouble too - the file is not in recognizable format in Excel.