What is the best method for matching and merging records that have slight variations in spelling or format within the same dataset?
What is the best method for matching and merging records that have slight variations in spelling or format within the same dataset?
I would use the “Cluster and Edit” function in the colummn menu. With that, you can standardize the text of the cells of that column.
Regards, Antoine
Yup, cluster & Edit, or text facet may also help
Sara