Delete rows with a specific value from my query tables

[Anonymous]

I have many tables containing equal headers, what I need is to delete the rows when this header is repeated.

In this way I would only have one MAIN header and the others would eliminate them.

I could not filter and delete because the process must be automatable and I could not know how many times the row is repeated

The option of filtering and eliminating would not help me because in some cases the header containing the value moves a cell (variable) and that does not remove all the values ​​when filtering because I do not know which column can contain the value to I need to remove I came up with the option of placing a conditional column so that by placing the data to be deleted as an option to filter in that column and knowing which row contains the data to be repeated. Another option that probe but does not work is to use the Table.RemoveMatchingRows function in M, but it does not delete the data that I place as parameters.

[CheenuSing]

Hi @Anonymous 

Can you upload sampledata, pbix and output expected to Google/One Drive and share the link here to find a solution.

Cheers

CheenuSing