how to convert row wise data into column wise in excel sheet


  • How to convert column wise into row wise ,my source is excel and my destinatoin also is excel


    how to insert column wise data into row wise  in excel sheet

    Monday, September 02, 2013 6:12 AM


  • Hi,

    Do you mean that you want to show columns' date in rows?

    Please try to do following steps:

    • Copy the date you want
    • Paste Special in the sheet where you want

    Please refer to the following picture:


    George Zhao
    TechNet Community Support

    Tuesday, September 03, 2013 2:14 AM