[HELP] How to delete unnecessary rows which come before specific keyword

[msyosd]

Hi, Alteryx experts,

Could you please share your brilliant idea to delete unnecessary rows and keep necessary rows by keyword in one of the columns?
In the case of the attached sample financial statements, I want to delete the unnecessary BS part, which comes before and "Total Liabilities and Capital."

Basically, I only need the PL part in the sample file.

Thank you so much for your attention and participation.

[DataNath · Accepted solution]

Hey @msyosd, I believe the following workflow ought to do the trick. If you run into any issues then let me know! The first 2 tools are just for general clean up of the input when bringing it into Alteryx.

[binuacs]

@msyosd one way of doing this

[msyosd]

@DataNath @binuacs Thank you so much; this is a simple but powerful solution!