Complex cleaning and formatting of the file

[SH_94]

Hi Community,

I would like to ask how to format the file so that we able to obtain the result as below:

Original File

Result wanted

I have also attached file below for your reference.

Many thanks for the help.

[Peachyco · Accepted solution]

I don't know a lot about your input file in terms of context (e.g. I don't know if it will ever change layout) so I designed a workflow based solely on the reference file presented in the OP. 😅