merge 2 sp list in single view web part

can I know How you marge 2 Lists in View??

 

any dependance column??

Yes your empid is reapeated because you have created a view but your list is not merged.

You should combine lists using a Data view web part creating a new linked resource. Refer this blogfor details. And afterwards you can export this combined Data View web part using javascript. Find all the details here for exporting. Exporting from a Data View web part would be dynamic and real time.

please exaplain ur issue lil properly ....

 

you can handle redundant data in list

using distinct key word