Forum

Help for a newbie p...
 
Notifications
Clear all

Help for a newbie please - Excel Power Query

3 Posts
3 Users
0 Reactions
66 Views
(@carla11)
Posts: 1
New Member
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
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: