How to Append 2 worksheets data into one sheet based on unique rows

hi
im extracting data from 2 sheets and appending into one sheet by considering unique values based on column(commentname)
every time i run the code it should be append the unique value to result sheet according to data1 or data2

can someone help or post on this

hi
Because its duplicated

Thanks