Forum Discussion
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 | 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
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!!
2 Replies
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
