Forum Discussion

michaelmichael's avatar
michaelmichael
Helper I
6 years ago
Solved

Removing rows in all tables

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 filte...
Need Help
  • michaelmichael's avatar
    michaelmichael
    6 years ago

    Okay - Sorted it.

     

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

     

    Thanks for your help.

michaelmichael's avatar
michaelmichael
Helper I
6 years ago

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's avatar
michaelmichael
Helper I
6 years ago

Okay - Sorted it.

 

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

 

Thanks for your help.