Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
66
Views
Topic starter
Is it possible to add a query step that will remove rows based on criteria? The criteria is a column with consistent text data in several rows of the imported data but doesn't need to be part of the final result. I'm guessing some sort of filter action but couldn't seem to find anything relevant on a quick Google search. TIA
Posted : 28/09/2022 12:51 pm
Hi Carla,
Please provide a sample file and show an example of the result you are looking for.
Regards
Phil
Posted : 28/09/2022 6:58 pm
Hi Carla,
You can do this using the filter button drop downs on each column. Have you tried this? If you're still stuck, please provide a sample file as Phil mentioned.
Mynda
Posted : 28/09/2022 8:14 pm