ozdusoleil.com
How to Split Columns with Power Query with Variable Delimiters - Oz du Soleil
It’s easy to split columns by delimiter but there’s a problem if you need to automate the parsing. Get & Transform (Power Query) hard-codes a number the first time you create the query, and if that number is exceeded, new data will just disappear. This video shows how to set up a query so that …