Filter out the non-null value and also the null value below it

[Anonymous]

Hi everyone, I have been working on this and I hope that I really need help to get get some support on this. This would mean a lot to me.

This is the information that I input from PDF to power query. I give out the information I need to process.

Below are the the data that I have extracted from pdf by power query, now the task that I want to do is to fitler out and take out the 4 section (Ngăn chặn, Phản ứng, Lưu trữ, Xử lý) with the column data next to it. But each of the section will maybe have some null value under, which those rows also contains the data also. Also each of the section rows is not fixed, for example: "Ngăn chặn" can have 2 or 3 rows of data.

For instance I want to turn it to be like this.

I hope that you can support me. Thank you a lot !

[artemus]

If you want to manually touch up your data set. I would advise adding an index column to your table, and then filtering out each index value that has a row you want to delete.

[Anonymous]

Hi Artemus,

But each of the section will maybe have some null value under, which those rows also contains the data also. Also each of the section rows is not fixed, for example: "Ngăn chặn" can have 2 or 3 rows of data.

So after I have the index value what should I do next.

Thank you a lot 

[artemus]

To remove a row, you can right click the index number and choose Filter -> Does not equal.