Hello,How I can split in each raw each line in record to several raws in M Query? The raw data looks like that: Column1Column2Raw1L5L8PTP2L2L1L384/88247975/85ALMT0.00%0.00%2.00%2.10%2.10%2.10%2.10%2.10%1.70%1.80%2.10%1.80%2.10%And I like to get next:Column1Column2L50.00%L80.00%PT2.00%P22.10%L22.10%L12.10%L32.10%84/882.10%241.70%791.80%75/852.10%AL1.80%MT2.10%

@Denis_SlavDuplicate 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 🙂YoutubeLinkedin

Split lines in rows to table M Query | Microsoft Fabric Community

Forum Discussion

Related content

Splitting Column values

Splitting tables between directquery and import mode

Line Break in Table Column Headers

Split Table

Split measures table