Data Transformation

[nishantr]

Hi Everyone ,

I was wondering if I can seperate the different cuisines in each row seprately .

The delimiter option won't work as every row has different number of options available.

Thank you 

[v-yetao1-msft · Accepted solution]

Hi @nishantr 

Is this the result you want ?

You can use Split Column by Delimiter in Power Query . Split by “ , ” and split into Rows .

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@nishantr 

You can right-click on the column > Split Colum > By Delimiter then choose the Rows under Advanced options as follows