How to Split Columns with Power Query with Variable Delimiters

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 all future data will be integrated. This involves creating a list of lists in Get and Transform then converting it back to a table.

There is one trick and I learned it from DataChant:


My book: Guerrilla Data Analysis 2nd Edition
My old blog: