How to Split Data with Delimiters into New Rows

Musili Adebayo
2 min readMar 17, 2022

I had a challenge at work where I had to split words with delimiters in a column into a new row and also count them in Power Query. That experience inspired this article where I will be showing you how to do that.

Below is the data and the expected result i hope to achieve from this article:

Load the data into Power Query, ➡ Click on Transform ➡ Split Column ➡By Delimiter( In this case, my delimiter is a forward slash “/”).

The drop-down below will pop-up after clicking on By Delimiter. Selecting the advance option will give you the option to split into Rows ➡ OK.

The result below shows the data has been splitted into rows. However, we have to pay attention to the fact that the data has been duplicated. Afterwards, we can go ahead and further analyse the data to achieve our desired result.

--

--

Musili Adebayo

I am quite the storyteller, once a good idea pops up in my head. I enjoy talking about modern data stack and how to leverage them.