hi Folks
Was recently chatting to senior person in IT department. He described how he had once counted 427 versions of a name in the organisation he was working in...and I found myself wondering what would be the most effective way to use Power Query in that situation e.g. if I have a supplier called Acme business and it is spelled like this....
Acme business Ltd
Business Acme Limited
Acme, Business Ltd
etc.
What Power Query guidelines could I suggest to him to help get this data cleaned up? Thanks.
Was recently chatting to senior person in IT department. He described how he had once counted 427 versions of a name in the organisation he was working in...and I found myself wondering what would be the most effective way to use Power Query in that situation e.g. if I have a supplier called Acme business and it is spelled like this....
Acme business Ltd
Business Acme Limited
Acme, Business Ltd
etc.
What Power Query guidelines could I suggest to him to help get this data cleaned up? Thanks.
