Transform Data $-$ Split Column

A common transformation in Power Query is splitting a column by delimiter. Sometimes, our data has a different number of delimiters in each row. In this scenario, how can we split the column by delimiter and still get the intended results?

Split the column by delimiter in multiple steps

Split the column by delimiter all at once

Split the column only if the delimiter is a comma

We cannot split the column by delimiter