How to change Row of Data into Column Data in Excel?

Sometimes we may need to rearrange the Data arranged in a Row into Data under columns.




Refer the above screenshot showing Employee name and Employee Id in separate rows.

If we want to rearrange this data into columns, just follow below steps in Excel.

1. Select the existing Rows and Copy.
2. Put the Cursor at required place/cell and then do mouse right click.
3. Click "Paste Special" in the Context menu.
4. Below pop-up Dialog will appear.


5.Check "the Transpose" and click 'OK'. Now the Data will be rearranged under columns as shown in the below screenshot.


More Articles...