Transpose columns to rows keeping first column as it is in excel 2013 programmitically RRS feed

  • Question

  • Hello,

    I have data in the below format.

    Resource C/C++ C# .Net Core ASP.Net
    John   3 3 3
    Bill   2   2
    Mohan 1 1 1 1

    This is the result I am looking to achieve.

    Output Result
    Resource Skill Value
    John C# 3
    John .Net Core 3
    John ASP.Net 3
    Bill C# 2
    Bill ASP.Net 2
    Mohan C/C++ 1
    Mohan C# 1
    Mohan .Net Core 1
    Mohan ASP.Net 1

    As I don't find any direct way in excel to transpose the data as per my requirement, so i am looking it to do it pro-grammatically but as i never wrote macro earlier (VBA), can anyone help me how can I proceed?


    Saturday, October 19, 2019 1:15 PM


All replies