Forum Discussion

arafmustavi's avatar
arafmustavi
Frequent Visitor
3 years ago
Solved

Data Split into Tables and Append Tables

Hi, I have loaded the data from and excel and the excel sheet has three table in a sheet. My dataset looks like this CATEGORY A  CATEGORY B CATEGORY C PRODUCT  PRICE  PRODUCT  PRICE   PRODUCT  PR...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi arafmustavi ,

     

    Supposing below is your data.

    You can duplicate two tables and set three tabls to the same column names, "PRODUCT", "PRICE", and "CATEOGRY".

    The "CATEGORY" is a custom column added manually.

    Table:

    Table (2):

    Table (3):

    Append them.

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.