Merging Queries not Matching

[Beginner2022]

Hi,

I am hoping someone can help me. I have been using merge queires for a while and I usally have great success with it however with my current merge not all the lines are matching up. I filtered the null values to review the values which didnt merge and copied them into excel. I then took the original query to review how the data might be misalligned and when I used the 'highlight duplicate values' conditional formatting in excel it is highlighting that the cells are exactly the same so they should merge no problem in power bi but they dont seem to allign.

Is there anything else I can do? I have trimmed the text to ensure no excess spaces and they still dont merge.

Thanks

[Vijay_A_Verma]

We need to see sample data of both tables and also code which you are using to perform merge....If you can also point out the issue in the result, that would be great.