I’m trying to merge two tables. Both consist of two columns each [id, name]. Table1 carries a series of id’s (duplicate id’s present) and empty cells for the name. Table2 has the information on the names for each id. I want to merge them, so that each cell holds a value, even though they are redundant.
When I use the Merge.DAT with ‘replace cells by rows’ it does the job only once per matching id. It does not fill the cell with a name for a duplicate id. Do I understand this method wrong or is there a little bug?
I don’t know if the merge DAT supports multiple matches - if you don’t have a huge table / need a solution right away you can get there with a script DAT: merge_tables_script_dat.tox (1014 Bytes)