Help

[Sillsree15]

HI All,

I need help to ficheh the spicific sting from the existion column and create as new row in new table .

Original data is like below 

ID	Name	Effects
121	Sree,Navee,Break	40
122	Kousik,Prana,Sree,Sil	100

I need like below

ID	Name	Effects
121	sree	40
121	Navee	40
122	Break	40
122	Kousik	100
122	Prana	100
122	Sree	100
122	Sil	100

Thanks in advance for help.

Sreenivas

[Sillsree15]

Thank  man

[Kishore_KVN · Accepted solution]

Hello @Sillsree15 ,

Follow below steps to achieve it.

1. Go to Power Query Editor (Transform Data)

2. Select Name column and click on split column using delimiter then in advanced option change to rows. Its looks as below:

Your output looks as below:

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