Forum Discussion
Split collum challenge
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.
You're welcome :smileyhappy:
Nolock . One more information: is it possibile to get the same result using only the menu options (without M code)? How?
Thanks again for your kind support.
Almost everything yes. You can split a column by many delimiters (even custom delimiters) into rows (see screenshot in the earlier post) but I didn't find any option for CR or LF among delimiters. So, I clicked everything in UI and at the end I replaced the delimiter:
Splitter.SplitTextByDelimiter("ANOTHER_DELIMITER", QuoteStyle.None)
with
Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.None)