Forum Discussion
Parse txt
Dear Expert, Could you please share how to parse the attached txt to Excel , So for example the ones underlined in read should be in one row and the second sub-headers in another ...
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.
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.
