Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

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.