Forum Discussion

michaelmichael's avatar
michaelmichael
Icon for Helper I rankHelper 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
    Icon for Helper I rankHelper 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
      Icon for Helper I rankHelper 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.