Forum Discussion
IanDavies
Helper III
Helper IIIMerging multiple tables (more than two) to create a single list of assets
I have data from a number of sources about computers in the business, not all sources havr all computers (ergo not all computers are in all sources) I need to merge the data so that overlapping da...
Hi IanDavies ,
I create three tables as you mentioned.
Then I think you need to make relationships among them.
Next you can go to Power Query and use Append.
You can remove duplicates and use Merge Queries.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi IanDavies ,
I create three tables as you mentioned.
Then I think you need to make relationships among them.
Next you can go to Power Query and use Append.
You can remove duplicates and use Merge Queries.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.