How to Split Columns with Power Query with Variable Delimiters

/in /by

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:

Split & Merge Columns – Pitfalls #7 and #8

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2