[HELP] How to merge two identical sheets in one sheet (with formulas)? Without duplicates

Hi guys,
I have two different sheets that have the same layout, but come from two different sheets with completely different formulas. I´ve wanted to make a single data base so I could use in the pivot table, so I need to merge them, if possible avoiding possible duplicates.
My problem is that they are dynamic every day each of them will have new data added in, and I´ve wanted to merge them both on a single sheet automatically.
This problem is part of a huge sheet that I´ve wanted to work without any interaction, I cannot think of any way I would merge both, hopefully someone can help me with that.

Here follows the Example Sheet:

Thanks in Advance!

Hi guys, still looking for a solution. If anyone have any clues let me know!

This won't deal with duplicates, but it will append the one table beneath the other using formula only. (You could add extra columns to detect and adjust for duplicate values)

In 'Merged Sheets' enter in cell A2, and copy down and across

=IF(ROW($A2)<=COUNTA(Sheet1!$A:$A),Sheet1!A2,OFFSET(Sheet2!$A$1,ROW($A2)-COUNTA(Sheet1!$A:$A),COLUMN(Sheet2!A$1)-1))

Originally Posted by cyiangou

This won't deal with duplicates, but it will append the one table beneath the other using formula only. (You could add extra columns to detect and adjust for duplicate values)

In 'Merged Sheets' enter in cell A2, and copy down and across

=IF(ROW($A2)<=COUNTA(Sheet1!$A:$A),Sheet1!A2,OFFSET(Sheet2!$A$1,ROW($A2)-COUNTA(Sheet1!$A:$A),COLUMN(Sheet2!A$1)-1))

cyiangou, Thank you also for the contribution. I will give it a try also. Really glad!!!

Originally Posted by ChemistB

Here's what I did.
1. First converted sheets1 and 2 to tables. Tables have the added value that they automatically format new rows and add formulas to them.

Then in Sheet2, I added a column called "Key" with this formula
=IF(ISNUMBER(MATCH([@[Full Description]],Table1[Full Description],0)), "",MAX($F$1:F1)+1) It gives sequential numbers to all non-duplicate rows.

Then in Merged sheet, in A2, dragged right and copied down

=IFERROR(INDEX(Table1[Due Date], ROWS($A$1:$A1)), IFERROR( INDEX(Table2[Due Date], MATCH(ROWS($A$1:$A1)-ROWS(Table1[Due Date]), Table2[[Key]:[Key]],0)),""))
Does that meet your criteria?

Seems great! I will give it a try, and let you know!