Forum Discussion
Solved
Power query - remove row based on condition and if value exists
the data is similar to the example below Field1 Field2 A 123456 A 125467 B 123456 B 3214 the value in Field2 must only occur once in the table, and the record wit...
First step I'd do would be to make a column that highlights whether your Field2 is duplicated, this explains it better than I can:
https://www.excelguru.ca/blog/2015/12/09/identify-duplicates-using-power-query/
Once you've got that, you can concatenate it with Field1, and filter out anything that has a value B1, B2 etc
jthomson
Solution Sage
Solution SageFirst step I'd do would be to make a column that highlights whether your Field2 is duplicated, this explains it better than I can:
https://www.excelguru.ca/blog/2015/12/09/identify-duplicates-using-power-query/
Once you've got that, you can concatenate it with Field1, and filter out anything that has a value B1, B2 etc