Forum Discussion
Split field into multiple column
Perfect. In retrospect, those two screenshots is what you should have posted in your first post 😉
Also, my bad on the report I uploaded, I somehow must not have saved the last version I was working with.Try this instead: https://www.dropbox.com/s/fw81h93f73mi47m/Split%20field%20into%20multiple%20column2.pbix?dl=0
The split column in Power Query is still your best option to handle this.
First split your column by the left most " - ", that is space score space:
Then split the remaining column by #(lf):
But this step requires that you manually edit M-code in the Advances editor according to the link in my prevoius answer.
Once that is solved, your data should look like this:
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Thanks so much, I am sorry I was not clare, my example is all in one filed, but not three fields in three row.
Here is a screenshot of my data, one field has two notes, another two has nothing, and another one only has one field. I need to split the notes
Could you, based on the sample data you have provided, show in an excel sheet how you would like your data to look like at the end?
Here is my data in powerbi, i would to see either split the multiple worknotes in the same field into multiple column, or split it into multi row. However if it is multi row, the assigned to has to repeat, Also, one could have no worknotes, one could have one worknote, and could have 2,3,4,5 or more