Trick 015 Split columns into multiple columns, automatically add columns with power query

    As we all know in Excel there is a Power Query application. With the power of power query, we can handle a lot of complex jobs such as splitting columns, rotating rows, rotating tables, merging tables....

    But sometimes we also get some errors eg. When we split a column into multiple columns done by power query, in first execution we get perfect result.

    But when we update more data, with a larger data, we repeat the steps in the power query when splitting the column into multiple columns. Then we notice that a part of the data is not updated. That's because during our work with power query, Power query didn't automatically add us columns for the newly added data.

With this example we will know where the error is and we can do it comfortably as we update more data.