Help Needed - Extracting Columns Duplicate and Unique Elements

Greetings to fellow members,

I am new to this community and this is my first post in this forum.

I am troubled with a problem of extracting out the identified duplicate or unique elements present in the column data: actually it's not as simple (for me at least). I send you herewith the image of the data in excel file, its attached with this post. excel sample image.jpg

I need to find out the duplicate elements from the columns A and D, then paste it down in the column G alongwith the corresponding elements from columns B and E. It means I'd need to paste down the data in three columns, where the values in new columns H and I correspond to the element in the column G, as it did originally, before i took them out and pasted elsewhere.

The problem is that I'll have to deal with dozens of files like this and the position of unique values may vary each time, restricting the use of "action-copied" excel macros. I have already tried with functions such as, vlookup, if and countif together, iserror and match, but nothing seems to be working when i register them in macros (actions copying method). The four columns contain 7600 data each.

Please write back to me if you need more details in order to make trials. The excel file with the data is linked here:Sample column compare.xlsx

I, very urgently, need your help in order to carry on my work.

Thanks in advance and best regards,
Sanjeev Pandey