Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |