Thanks Cedric I should have gone onto explain that the “make” output is used to extract the make from the text string based on its length so it nee...
Thanks again Mynda. I will look into that but thought I would add in one more note that makes me wonder what the refresh delay is all about - ...
Thanks Mynda, Always great tips in these posts and much appreciated, I have already used most of them but have opened every thread to go over and c...
Amazing Phil, Thanks for that, works a treat and has shown me about half a dozen new steps / tricks / methods that I would have taken a long time t...
Thanks again Alan, FYI - I ran the merge tables with a real data set of 500 lines and then tried the full list of Keywords for Makes and Categories...
Hi Alan, 3 sheets attached Sample source data that has my cleaning query Refence table for "Makes", i have cut this down to about a dozen exa...
Thanks Alan, I appreciate the input but can't see what the parameter key achieves and appears to my PQ newbie eye as just a third table so I might ...