Split by delimeter

[Afiq_Danial]

Hi, 

Are there any ways in DAX or Power Query for me to seperate names with slash at the delimeter. The column in my table looks like this:

I want it to be like:

Thanks in advance!

[NikhilKumar · Accepted solution]

Hi @Afiq_Danial ,

In Power Query, you can achieve it if you split column as shown below-

[Afiq_Danial]

Thanks so much! Funny how I didnt see that i have the option to split into rows