Forum Discussion
Denis_Slav
6 years agoHelper III
Split lines in rows to table M Query
Hello, How I can split in each raw each line in record to several raws in M Query? The raw data looks like that: Column1 Column2 Raw1 L5 L8 PT P2 L2 L1 L3 84/88 24 79 75/85 AL...
- 6 years ago
@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 🙂
amitchandak
6 years agoSuper User
Denis_Slav , not very clear, refer if this can help
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/