Posts by munayus

  • Insert Rows as many as a Cell's Value

    Dear experts,


    Need your help in this case.
    I have a table consisting of two columns, column one for "Item" and column two for "Qty"
    I need to create new table that is the result when one inserts new rows as many as "Qty" owned by the "Item".
    You can see the example below.


    Before

    ItemQty
    a3
    b4
    c2


    After

    ItemLabel
    a
    a
    a
    b
    b
    b
    b
    c
    c


    My colleague suggests that I use Macro Excel / VBA for this case. But I'm unfamiliar with it, so really need your help.


    Regards,

  • Compile Two Tables to One

    Hello, experts,


    I Need help to compile two tables in different sheets into one, merged table.
    I'll illustrate below:
    Table 1

    Data1Owner
    Ax
    Bx
    Cx
    Dx
    Ex
    Jy
    Ky
    Ly
    My



    Table 2

    Data2Owner
    ax
    bx
    cx
    ay
    by



    so it will result like this:
    Table Result

    Data1Data2Owner
    Aax
    Bbx
    Ccx
    Dx
    Ex
    Jay
    Kby
    Ly
    My



    Please help for the macro. I'm actually not a programmer here so I hardly know how to create such.
    Thanks.