Splitting Columns

Splitting columns divides a single column into multiple columns, based on a delimiter, a fixed number of characters, or by position. This is useful for cases like separating a full name into first and last name, or breaking apart a combined date and time field. Power Query keeps track of the split as one of the applied steps, so it can be adjusted later.