Last seen: Jul 7, 2026
Please see attached and link the query to your own CSV file. I had to fiddle around a bit to get your data on my machine, but believe it worked. I inc...
There is no attachment. Please try again and don't forget to press 'Start upload' before you submit your reply.
Thanks for the file. My guess would be that you want to identify the transactions where names in columns D an H are the same or at least very similar....
See is the attached file contains the correct query outcome. I filtered the query to only load 7A/2 for the 21st of September so that it can be compar...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Hmm.... not easy. Will get back to you if not someone else has some clever ideas.
No file attached. Please try again. This time, press the 'Start upload' button and wait for it to finish before you press 'Submit Reply'.
Good to see you are making progress. Perhaps that Phil's blog article (link below) about finding keywords within text strings is helpful. I believe it...
That helps, but now please give a few examples of some end results. For instance, where would you match, let's say the first 10 entries from the ETM t...
Could you perhaps provide a sample with more realistic scenarios then? Working off overly simplified examples often results in overly simplified solut...
To make it work I also changed the data set-up a little. Please see if the attached does what you had in mind. If not, perhaps a good idea to come-up ...
I believe that requires Power Pivot and some DAX measures. Can you upload an Excel file? Otherwise it will be difficult to help you further. And can y...
Glad it worked out and that it got you into learning PQ. It will be a life changer! With regard to the applied steps, after connecting to the Sourc...
You are probably better off by using Power Query (PQ) to begin with and skip Text-to-columns. But based on your example, I have used PQ to transform T...
Hi Robert, All was done by clicking in the user interface. The Trim 'function' sit in the Transform tab under Format. All it does is get rid of lea...