Forum Discussion
Combining two lists
Dear Forum Users, I have a question regarding fusing two lists of information in to one, i color coded them so it is clear where the information is pulled from. How do i go about this? ...
Fixing data may not be an option, we're talking about 40000 lines. I will try matching on adresses.
You may want to consider using Power Query to merge these lists. It will avoid the need for thousands of formulas, and you can easily find out which rows don't have a match.
It's straightforward to do this. For each of your lists, you need to go to the Data tab of the ribbon, then choose "From Table/Range" to create a query for each.
Once you've created a query for each list, you can merge them as described in this article.
https://support.microsoft.com/en-us/office/create-a-fuzzy-match-power-query-ffdd5082-c0c8-4c8e-a794-bd3962b90649
It's straightforward to do this. For each of your lists, you need to go to the Data tab of the ribbon, then choose "From Table/Range" to create a query for each.
Once you've created a query for each list, you can merge them as described in this article.
https://support.microsoft.com/en-us/office/create-a-fuzzy-match-power-query-ffdd5082-c0c8-4c8e-a794-bd3962b90649