When this is the case, you can use Power Query’s Extract and Split Column features to extract delimited strings into their components. I’m using Microsoft 365 Desktop and Power Query in ...

In this article, I’ll use two IF () functions to split a simple “database” sheet into multiple columns, based on a value in another column.