Saturday, October 20, 2012

How to Convert Rows Into Columns


1.
Open Excel and input the following data going across in cells 'A3 through L3' the months January through December. In cells 'A4 through L4' enter random figures as shown in the illustration. (NOTE: You can use an existing chart of your own, instead.)
2. Highlight the range starting from cells 'A3 through L4'. Do this by placing the mouse pointer in cell A3 and left-clicking the mouse once. While still holding down the mouse pointer, drag it to cover the last cell position in the range of data which is column L and row 4 (L4) and then let go of the mouse.
3.
Select 'Edit' and then choose 'Copy' from the toolbar menu.
4.
Place the mouse pointer in cell 'A6'. Right-click and select 'Paste Special.'
5.
Under the Paste section in the Paste Special dialogue box, place a check next to 'All', and under the Operation section, check 'None.' Finally, check 'Transpose' near the bottom of the Paste Special dialog box and then press 'OK.'
6.
Verify that the data has been transposed correctly. To clean up the spreadsheet proceed to Step 7.
7.
Highlight rows 3 and 4 by placing the mouse pointer at the beginning of row 3. Left-click and hold down the mouse to cover row 4 and then release the mouse. Right-click and press 'Delete.'
8.
Verify that the conversion was successful by viewing the data. Make further adjustments, deleting extra rows or adding titles as needed.

Blogger news