Forum Discussion
Parsing Text usng Power Query
Dear Experts, Need your help, in Parsing the attached txt into two worksheets, based on the purpose So , one worksheet for RLF and other for the BEAM_FAILURE, each work...
Very clean and consistent file, no problem:
Filter on text starts with " Purpose ="
Extract what's after "=" as new column [Purpose]
Fill down
Remove nulls
After that for each [Purpose] it's only a question of a couple of select rows and trimming before splitting the column
Thanks Lorenzo but after this ,
I didn't understood , could you please share complete steps for what to be done after using the Filled Down,
Thanks in Advance,
Br,
Anupam