I have two tables of data and I need them merged, however there isn't a very clear link between the tables. the names between the two tables should be used to match, however they will not be identical. for example table 1 may say "product x y z 100" and table 2 may say "z y product x" - there are similarities that can be detected with an algorithm, for example number of words that are matching (but sequence of words doesn't matter as much). there is one column that will match between the two tables, but it doesn't contain unique values.
There are about 8000 rows in table 1 and 1000 rows in table 2 so there won't be 1:1 matches for all, but I'm hoping that table 2 contains all data that table 1 does. table 1 contains all unique values, so there will never be two values from table 2 that match table 1.
The output would contain all rows from table 1 and matching identification from table 2.
55 freelancers are bidding on average $134 for this job
HI I am ready to start the work.I can do this work [login to view URL] if you are interested to me message me..............................Thanks.
Hi, my name is Daniel, i am an Excel Expert and vba programmer, i have a great experience processing data sets, i am sure i will find the right algorithm to match those tables
Sir, I have read your project description & it will be my immense pleasure to work for you. You can send in the details of your complete project work & method so we can start the work as soon as possible.