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.