get complement rows and distinct union

[imla]

how can generate attached pivot Tables.

 

[GraH - Guido]

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.

 

[imla]

thanks, it worked

 

[GraH - Guido]

Great, I tweaked my version a bit. Removed some steps and queries. But same basic idea.

 

[imla]

Great, I tweaked my version a bit. Removed some steps and queries. But same basic idea.

its perfect