Forum Discussion

nishantr's avatar
nishantr
Frequent Visitor
4 years ago
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...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.