Forum Discussion
Split by comma into row
Hi NurAmirah_MY
You needs to two times replace value as space are not consistent in text
Step 1 Replace Value
Step 2 - Replace value
Then Split
https://drive.google.com/file/d/1yV31w4lgjBBkFXymCQ9AV4yJM3Uk6OuB/view?usp=sharing
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
Pijush
Hi PijushRoy
Thanks for the solution. I have tried but the word with , that I want to keep still splitting. I have replave value of "," with "#" 2 times and split by row.
I'm not sure what went wrong. Let me repharse the example:
eg: Data I have --> Trust,Happiness, enjoyment and excited,pessimistic, optimistic
Data I want it to be by row:Trust
Happiness, enjoyment and excited
pessimistic
optimistic
Does the same solutiom applied? Thanks.
what's the difference between the comma after "Happiness" and "pessimistic"?
The comma after "Happiness" has a space. The comma after "Pessimistic" don't has a space.
Hi NurAmirah_MY
Please share the sample data that you are using in excel format
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216Hi PijushRoy
The questions asked in the survey are:
Over the 12 months, what are the topics you would like to learn? Select all that apply
- Foreign exchange
- Pension
- Life Insurance, Takaful and Hibah
- Bonds & Loans
Here are the sample data in Excel format. Let me know if this is sufficient for the testing. Thanks.
Resp_ID Over the 12 months, what are the topics you would like to learn? Select all that apply test01 Foreign exchange,Pension test02 Life Insurance, Takaful and Hibah,Pension test03 Pension,Bonds & Loan test04 Bonds & Loans,Foreign exchange,Pension,Life Insurance, Takaful and Hibah
