Hi all experts,

I have four excel sheet with different data fields including one combine field subjectid and i want to merge all data in master table. Some rows are duplicate please guide what is the best method for merging of all four sheet records into one master sheet. Moreover, how to remove the duplicate entries if combine id i.e. subject id format is like this:


Subject ids
a1ci00000001bNp
a1ci00000001c3o
a1ci00000001bc2
a1ci00000001cEz
a1ci000000034BI
a1ci000000034Ff

Regards

Shehbaz H.