Forum Discussion
Solved
Help
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...
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!!
Thank man