If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
In cell B2 of Sheet1:
=TEXTJOIN(",",TRUE,FILTER(Sheet2!$A$2:$A$4,ISNUMBER(SEARCH(" " & TRIM(A2) & " "," "
Use Text to Columns: and finish up with: ...
I have tried with this code but it does not run the query for each row (though it does not recognize the [Query] column)
NPowerQuery = Sql.Database(dBaseIP,
I have read and will follow all the rules and guideline... Please let me know if I have missed something, here's where I have posted my...
hi Ken, Nice to be in contact with you again. I think I got this method from one of your posts like 5-6 years ago. ...
Knowledge Base Articles By Category
Recent Forum Posts
VlookUp Crawls
In cell B2 of Sheet1:
=TEXTJOIN(",",TRUE,FILTER(Sheet2!$A$2:$A$4,ISNUMBER(SEARCH(" " & TRIM(A2) & " "," "