Forum Discussion

chavanr's avatar
chavanr
Resolver I
4 years ago
Solved

Need to clean data using LIKE function or in M query.

Hi there,

 

I am trying to clean a column 

 

in the above screenshot. e.g. Furniture, Mattresses, Other, Pallets, Gardenwaste is a category which i want to seperate in another column. Also there is a description in some rows like "full bottles of fizzy..." and other rows above it.

i want it to be blank as it does not belong to any category.

 

Can i use LIKE function in M query

 

Cheers,