Problem I've been tasked to tidy up some very messy data containing a mix of text and numbers and wish to use power query to separate codes from the data. Fortu
This question will seek multiple approaches LET/LAMBDA VBA UDF and Power Query Function, so there will be no single right answer, but a solicitation of approach
My data lives in Salesforce objects and I am trying to connect Power Query to Salesforce Objects. The limitation here is that I have to extract the whole object
I have a power query function, e.g. getData with one parameter filename Can I invoke that function directly in a vba variable? Something like: Sub MyTest() D
I had similar question (link below), but it just lets say "add-on" to my issue that I found on the way. Find all code combinations using text string in Power Qu