Dynamic column changes handler

Stuquan,

Right, that's why I was thinking of dynamically getting a column count each day. You would essentially be creating dynamic M that adjusts to the number of columns available on any given day.

I did some research and found the links below. The first link seems like the simplest approach, which is to merge all columns using a delimiter, and then split the column by that delimiter.

https://www.youtube.com/watch?v=dYXVTAIOcw0 

https://community.powerbi.com/t5/Power-Query/Split-varying-number-of-columns-into-4-columns-each/m-p/936185 

The example below uses the parameter MissingField.Ignore. I guess you could list the maximum number of columns you might have, and then this parameter would cause any non-existent columns to be ignored.

https://www.mrexcel.com/board/threads/powerquery-pdf-file-with-varying-number-of-columns.1218981/