Move rows based on cells!

Hi,


for giving an example here I'm using few rows but actual data
contains hundreds of rows.


I have three sheets called DAILY,RECORD & MERGE.
DAILY & RECORD sheets have eight columns each.
DAILY sheet has details of daily wages,allowances,overtime etc
while RECORD sheet has accumulated values of the same.

what I want is a move (not copy) of two sheets ("DAILY" & "RECORD") based on serial's (in column "A") in one sheet ("MERGE").

like in "DAILY" sheet in column "A" there's a serial ID "AL"
now if in "RECORD" sheet there's also serial ID "AL"

Row from "DAILY" sheet will be moved to "MERGE" sheet (from column "A" to "H") &
Also Row from "RECORD" sheet will be moved to "MERGE" sheet (from column "J" to "Q")
But in same Row of "MERGE" sheet (and so on).

so only serials which are not identical in "DAILY" & "RECORD" sheet would be left & identicals would be in "MERGE" sheet.

I've also attached file for details!

if anybody could suggest any "MACRO" or "POWER QUERY" way it'd really helpful.

Thanks!

Guys no suggestions!
I mean, I could use any help

I have no clue if what I'm asking is even possible or not coz my skills are at the beginning level
but if it is not possible I could re-ask my question in different way!

In worksheet "MERGE"

A1=IFERROR(INDEX(DAILY!A:A,SMALL(IFERROR(ROW(DAILY!$A$1:$A$5000)*1^MATCH(DAILY!$A$1:$A$5000,RECORD!$A:$A,),9^9),ROW(A1))),"")

Press control ,Shift and Enter (3 keys) to run (if you press them successfuly, you will see "{" and "}"
Then copy to right and down



J1=IF($A1="","",VLOOKUP($A1,RECORD!$A:$H,COLUMN(A1),))

then copy to right and down