Removing rows in all tables

[michaelmichael]

I'm trying to remove "OrderId" rows from all the tables in my query. Each table has repeating headers throughout. I've promoted the top header, and removed all blanks. But I can't find a way to filter all the tables so "OrderID" doesn't repeat all through my query. Thanks

[v-frfei-msft · Accepted solution]

Hi @michaelmichael ,

Table.SelectRows should help you in your scenario.

[v-frfei-msft · Accepted solution]

Hi @michaelmichael ,

Table.SelectRows should help you in your scenario.

[michaelmichael]

@v-frfei-msft Hi, I've tried SelectRows

= Table.SelectRows([Remove Blanks],####)

But in the #### I can't select the Column [OrderId] I want to filter

[michaelmichael · Accepted solution]

Okay - Sorted it.

I just expanded columns on the final table, and then filtered out the repeated data. Rookie error

Thanks for your help.