Removing Unwanted Rows Dynamically

[mosarahit48]

How to remove unequal numbers of "Top" & "Bottom" rows (together) dynamically from multiple files in Power Query?

[ppm1 · Accepted solution]

Is there a value in a column that is only in the top/bottom rows you want to skip. If so, you can just do a filter. You can also use Table.Skip, which can be used with a condition to dynamically skip rows You would do this in the #"Transform sample file" query (or a custom function) so that it gets applied dynamically to each file.

Table.Skip - PowerQuery M | Microsoft Learn

Pat

[mosarahit48]

Thanks for the solution, it works 😀