DW Faisalabad New Version

DW Faisalabad New Version
Please Jump to New Version
  • Working with Tables
  • While there are four types of database objects in Access, tables are arguably the most ... read more

    Thursday, 24 November 2016

    Transpose - MS Excel

    Some time we mistakenly typed complete list in colum in MS Excell but later it comes to know that it was to be written in row instead. So how can we change the complete legthy list.


    1. Just copy the complete list 


    2. And for pasting right click on your desired cell and from menu list click on the transpose pasting option as shown in the fingure below



    the following is the result.


    you can also conver row into column.

    Watch this in Video



    With the help of transpose (Trans-Position) pasting option we can easity change the row into column and column into row