Forum Discussion
Helper IIIMerging multiple tables (more than two) to create a single list of assets
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.
Helper IIIThanks for this, I tried that and I ended up with three different name columns rather than a single column with all the names in it. Like this:
Name
Table2.Name
Table3.Name
Am I to assume at this point, that having merged the three tables as you suggest, the only recourse is to somehow build a single name column to identify the (missing) assets that have been imported from tables 2 and 3?
Ian
Responsive ResidentYes indeed. Or you create such a column before merging the tables, as suggested by Anonymous .