Forum Discussion

amaniramahi's avatar
amaniramahi
Helper V
6 years ago
Solved

Merging Tables with same Headers

I have three tables for sales results for three different sales people.

Headers are Identical.

I need to merge the data under the same header row.

How am I suppoesed to do that?

and one more thing, I need to add a column to show the sales man who handled the sales process mentioned based on the source table.

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    For the first part, you would use "Append Queries" rather than mergeing them. It is all the way on the right side of the Home tab in Edit Queries.

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    For the first part, you would use "Append Queries" rather than mergeing them. It is all the way on the right side of the Home tab in Edit Queries.

     

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, amaniramahi 

     

    There are two primary ways of combining queries: merging and appendind. I assume that you need to append two queries. You may click 'Editor Query', go to Query Editor, select 'Home' ribbon, click 'Append Queries'. For the second question, could you please show us your sample data and expected result? Do mask sensitive data before uploading. Thanks.

     

    Best Regards

    Allan

     

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

     

    • amaniramahi's avatar
      amaniramahi
      Helper V
      6 years ago

      Thank you all for the help.

      for the second part please ignore, it will be solved if I created a unique key for each row and added some DAX.

      I solved it by adding the sales man name in the excel files (source data)