Forum Discussion
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 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-msft Hi, I've tried SelectRows
= Table.SelectRows([Remove Blanks],####)
But in the #### I can't select the Column [OrderId] I want to filter
Okay - Sorted it.
I just expanded columns on the final table, and then filtered out the repeated data. Rookie error
Thanks for your help.