Forum Discussion
Solved
Text extract
Dear Experts, I am attaching a txt file ( dump file/source) from where I need to get the data like in the below format:- Any PQ, or legacy formulas would be of great help! i...
With Power Query it gives
but I'm not sure I understood the logic correctly. Source is the stream of text lines without proper start and end.
Query itself definitely could be optimised.
the text file wouldn't open......can you attach it in addition to the xlsx file?
Attached again
