Forum Discussion
Split collum challenge
Hello, Power friends, I have the following data source in excel format. A B 144987 #199270 #199271 148511 #344827 #344816 #344838 #344823 148511 #344831 #344825 #344840 ...
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.
Nolock
Resident Rockstar
Resident RockstarHi Anonymous ,
the only thing you have to do is to split the column into rows by your delimiter.
If your delimiter is a new line, use #(cr) or #(lf) or both, it depends on your needs.
Very goog Nolock . This is the easy part. And how about the new table generation?
Thanks for your time.