Forum Discussion
Split lines in rows to table M Query
@Denis_Slav
Duplicate the source and divide by delimiter using the line font into rows and merge the two queries.You can download the file: HERE
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click the Thumbs-Up icon on the right if you like this answer 🙂
Can you post an image of what your data looks like Denis_Slav ? WHen I paste tht in Excel, it looks like this:
Those are all on separate rows, and columns, so nothing to split.
If you can provide a link to your actual source file via OneDrive, Dropbox, etc. that would help as I suspect you have some weird CR/LF characters that are getting filtered out when you paste here.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum