Splitting Columns is necessary in data cleaning and power query has one of the easiest features to split columns.
In this video, we looked at splitting the columns with the left-most delimiter. It leaves the first word in the present column, while moving every other text to a new column.