Need to clean data using LIKE function or in M query.
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.