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.