Forum Discussion
How to merge data
Hi, I have a two datasets. I appended 'table 1' and 'table 2' below. I'm trying to merge the location data from table 2 to table 1's rows using UPPER(NTID) and EMPNET_ID as the link to show the locat...
Hi mng ,
There's a feature you can merge, please refer to
Merge queries overview - Power Query | Microsoft Learn
You can merge as follows.
Expand the tables in the Table 2 column.
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.