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.           

     

Anonymous's avatar
Anonymous
Not applicable
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.