Solved: Split collum challenge - Page 2

Anonymous · ‎02-25-2019

Hello, Power friends,

I have the following data source in excel format.

I need to separate all data starting with "#" in column "B" to generate a new table with the relationship between column A and B, such as:

And, so on...

Note that there is no fixed number of strings beginning with "#" in column B.

Thanks for your time.

Nolock · ‎02-25-2019

I see, but that is exactly what I did before for you. Check the following 2 screenshots:

The steps Source and Navigation on the right hand site are importing Excel file into Power BI. You also see how the data looks like.

The 3rd step is the split described above. Again, you see the result of this step. And it is what you expect, I hope.

Split collum challenge