Power query merge n show duplicate value only

[sethlim1995]

In power query , you can merge two data source.
I have already done that but I want to retain just the duplicate ( side by side from merging two tables) values row of information.

Currently looks like this:._____ I need to just see:
E B C D E __________A B C D A
F G H J F. __________A F G H A
K L M N (blank) ____Q R S T Q
O P Q R (blank) ____Q V Z X Q

 

[Joe4]

Duplicate to: Power Query Help!

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.