Removing specific entries from list

Power Query
1

I have list of cost elements. I want to transform list based on following criteria.

  1. Remove Cost element starting with 3 excluding cost element mentioned in inclusion sheet
  2. Remove Cost element as per exclusion sheet
  3. Remove Cost elements starting with 9 & has length 10 e.g. remove 9900012345 but keep 990012

I have tried to do same but looking for better & faster approach.

My actual data has more than 1 Million rows.
Removing Specific Entries from list.xlsx (140.4 KB)

Thanks in advance

2

@prafullchavan1 Use this: Removing Specific Entries from list.xlsx (139.2 KB)

image
image281×851 7.51 KB

3

Thank You very much