• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

get complement rows and distinct union

What you want to achieve is easily done with Power Query.
Load both tables. Merge them twice. Once using left anti join, second one using right anti join. Then appending both.
Attached is a rough version.
 

Attachments

  • Copy of Question_2.xlsx
    174.9 KB · Views: 6
Great, I tweaked my version a bit. Removed some steps and queries. But same basic idea.
 

Attachments

  • Copy of Question_2.xlsx
    174.2 KB · Views: 5
Back
Top