Forum Discussion
Solved
Delete Rows from a Merged Query in power query editor
Hello - I have merged 2 tables in the power query editor to create a MergedTable. I want to delete all rows in the MergedTable in which category <> "Split". I can't figure out how to do tha...
Can you select a filter from the column header (category?)
I think I figured this out. Filtering in the power query removes the rows - you don't physically have to delete the records once you've set the filter. Duh. Thanks.