Hi Martin, thanks for your quick response!
In the workflows you sent, there is the column “Typo”, which I don’t have in my case.
I’ll make a quick example of what the table could contain:
Before merging the three address columns:
After merging:
Now I need to check how similar entries of this column are. The main cause is to get rid of duplicates, so duplicates musst be identified, even if they differ in order or if there are parts missing. This should work for bigger tables with about 100k rows and multiple addresses.