Forum Discussion
Solved
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...
@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 🙂
Denis_Slav - So are you saying that if this data was in Excel, the word Raw would be in Cell A1 and then all of Column1 would be in cell B1 and all of Column2 would be in cell C1?
Is this a text file or something else?