Split Wrapped cell and push then to the below rows

[Anonymous]

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.

[v-xiaotang]

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.

[negi007]

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