Forum Discussion
Filter Rows which don't start with letter defined in another table
If Anonymous's solution doesn't work, I recommend using Power Query to achieve this. You can do this with a couple of transformations and then using Merge to create a new table with the desired output.
You can refer to the Applied Steps in each of the respective tables to see what I did to get the output. However, the most important thing is that prior to Merging the tables, you create a new column in each table that will be used as the relationship that ensures the merge occurs correctly. I have created the 'validityCheck' column in each table and that is the basis of the Merge.
The output will look like this:
Hope this helps!
Theo
nganguyensyntax You could merge the tables on ID and Customer and create an "Include Y/N" custom column in the query editor to filter out rows. Using sample data:
Then filter out the "No" columns