Parse txt

Question

Dear Expert,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Could you please share how to parse the attached txt to Excel ,So for example the ones underlined in read should be in one rowand the second sub-headers in another row:-&nbsp;and then the data row.&nbsp;Many ThanksBr,Anupam

sergeibaklan · Answer

anupambit1797&nbsp;
What do you mean exactly - parsing in Power Query keeping sub-headers as rows before each section of data or something else? Perhaps you may share desired output, 2-3 columns is enough for the sample.

anupambit1797 · Answer

SergeiBaklanPlease find the same attached.&nbsp;Thanks &amp; RegardsAnupam Shrivastava

patrick2788 · Answer

anupambit1797&nbsp;I think you're trying to accomplish this?&nbsp;If so, you could use this:=LET(
    frame_subframe, CHOOSECOLS(data, {1, 2, 8, 9, 11, 12}),
    vector, TOCOL(frame_subframe),
    WRAPROWS(vector, 2)
)&nbsp;

sergeibaklan · Answer

anupambit1797&nbsp;
Is that sample for output or that's input? Question was how to transform some txt file into Excel one.
If above is output, I guess if to open txt as on screenshot it gives approximately the same.

Forum Discussion

Parse txt

Share

Resources