Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Split Wrapped cell and push then to the below rows

I have a data table set as below.

 

Using a power query I need to convert this table as below.

Can someone help me on the power query or the steps I need to follow in order to get the results.Thanks for the support.

 

 

 

2 Replies

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous in this case, you can split the value of cells into rows basis delimiter or other criteria.

     

     

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

    If you want to achieve this effect in power Bi, there needs to be a corresponding relationship between 1 and a, 2 and B, 3 and C, then you can use split function. Or, you can handle it in Excel, which may be easier.

     

    Best Regards,

    Community Support Team _Tang

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