Hi,
So I I received two lists for my merchandise and both are similar but differences do occur. I want to combine two lists that have similar names but I dont want the similar name to come up twice because I will end up purchasing two of those items. Heres an example below (file is massive).
list 1
hi
no
go
eat
bat
but
yack
list 2
hi
no
herring
durian
bear
go
combined
hi
no
go
eat
bat
but
yack
herring
durian
bear
Some names are common but I only want them to come up once in my combined list.
thanks
Kyle