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 thin...
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.

     

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)