If you have used the Split by feature of Power Query to delimit columns, it has a slight limitation. This feature only delimits to a fixed number of columns by hard coding the number of columns to split into. Later if your values change the split columns remain the same and do not change.. what … Continue reading Split by Variable Columns in Power Query