Replace duplicates with null by power query

Originally Posted by Haluk

@siddiqsh;

It seems that, you are making a "Left Join" on ID's of the 2 tables .... and you are getting the expected results.

So, what is your actual goal in this process?

Is something like shown in the below image will be OK for you?

thanks for your response. No it will not help. the results which I get by merging tables (attached excel sheet) is the desired one. only problem is repetitive values. I prefer solution through power query.