Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!!
Thank man
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!!
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |