Remove rows below text

[omezquita]

Hi,

I know how to remove a certain number of rows from the bottom of a file.

Is there a way to remove all rows below a text.

For example, I want to remove all the rows below the row that contains the text "Appendix".

Thanks!

 

[SteelReyn]

There are probably several ways to do this, but here's the first I thought of and it seems pretty clean:

1. Add a new custom column with the formula =if Text.Contains([ColumnNameToCheck], "Appendix") then 1 else null
2. Select the new column and go to the Transform tab -> Fill Up. That will leave everything below the first Appendix with a null value
3. Filter the new column to remove null values
4. Delete the new column since you no longer need it

 

[omezquita]

This makes a lot of sense and I can use it for other applications.

Thanks!