Forum Discussion
michaelmichael
Helper I
Helper IRemoving 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 filter all the tables so "OrderID" doesn't repeat all through my query. Thanks
Okay - Sorted it.
I just expanded columns on the final table, and then filtered out the repeated data. Rookie error
Thanks for your help.
3 Replies
v-frfei-msftCommunity Support
- 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
Okay - Sorted it.
I just expanded columns on the final table, and then filtered out the repeated data. Rookie error
Thanks for your help.