Forum Discussion

Helper I

6 years ago

Solved

Split field into multiple column

Hello everyone, I want to split one field into multiple columns or rows, the content in the field are like: 2020-01-03 02:21:12 PM - James (Work notes) plan resurrected notified to proceed ...

sturlaws
6 years ago
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

sturlaws

Resident Rockstar

6 years ago

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?

Yucy

Helper I

6 years ago

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

sturlaws
Resident Rockstar
6 years ago
I found a solution, but it might be a bit fragile. It relies on (Work notes) being at the end of the line that defines a new entry.

Here is a report which shows how it can be achieved: report
- Yucy
  Helper I
  6 years ago
  Much appreciated. But it still not I want😭
  - sturlaws
    Resident Rockstar
    6 years ago
    Then perhaps explain exactly what you want to achieve by using excel, and post a screenshot?

Forum Discussion

Split field into multiple column

Related content

Splitting Column values

Splitting columns into multiple rows

Split Data In Multiple Columns

Split a column into two separate columns

Splitting multiple columns using delimiter