Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Append Multiple Tabs

I am trying to append multiple tabs from the same workbook that do not all have the same column names I have deliberately created columns that should be the same, but are slightly different, for exam...
  • v-juanli-msft's avatar
    6 years ago

    Hi Anonymous 

    "Append" is based on the same column names, so if columns' name is not the same, it would not work.

    If you want to append mutiple tabs, you can do this way:

    right-click the excel name, then select "transform data",

    As you see above, the columns would be append based on the orders.

    so if you want it works, please reorder your columns in excel with the same order.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    dd