Forum Discussion
Solved
Data Transformation
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 y...
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.
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.